- 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