• Subject: Automation to send email from Group box
  • Author: David
  • Date: 27 Aug 2007
  • References:
Hello all, I'm not getting much support from IT, so my details may be a bit off. I have had them setup a group email on our exchange server. My Outlook has my inbox and the group inbox. In access, I have mapped to the group inbox, the location is on my c drive...\ local\Temp\Inbox I can modify the To, CC, BCC, Subject and Body of the email. How can I modify the FROM field so the email shows from the Group and not my personal email? Sample code I use for Outlook Automation in Access 2003 VBA. Set objOutlook = CreateObject("Outlook.Application") ' Create the message. Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg ' Add the To recipient(s) to the message. Set objOutlookRecip = .Recipients.Add("David@company.com") objOutlookRecip.Type = olTo Any assistance you can provide would be greatly appreciated. David
27 Aug 2007Automation to send email from Group box.David
27 Aug 2007\ Re: Automation to send email from Group box.Ken Slovak - [MVP - O...
27 Aug 2007   \ Re: Automation to send email from Group box.David
28 Aug 2007      \ Re: Automation to send email from Group box.Ken Slovak - [MVP - O...
All times are in (US) Eastern Daylight Time (GMT -4:00)