• 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)