Can you change the sender address with ms access vba?

[mkaeser]

Hello,

I am using ms access 2007 and outlook 2010. I have vba set up to send the output of a query to the body of an email. Is there a way I can specify which address to send this email FROM using ms access vba? This is going to be a split database, and every computer has different email addresses associated with it. However, this query email will need to be sent from the same email address (admin@blahblah) every time, so it would be useful to specify the query sends this email from admin@blahblah every time. Is this possible? From everything I am seeing on the internet, it does not seem to be....

 

[Frothingslosh]

Actually it is - at my last job, I had to have a database generate automated emails that went out via the company's 'noreply' address. I'm about to go to a meeting, but next time I have free time today I'll try to find you a link or two.

Edit: Here's a starting point: http://social.msdn.microsoft.com/Fo...-send-of-behalf-of-permission?forum=accessdev

 

[mkaeser]

Thank you for the quick reply Frothingslosh, I will check that out and report back with my results!

 

[Frothingslosh]

Okay, you technically can't change the FROM, but you can send on behalf of.

Another method you could use is to open an Outlook session using the login for the email you want, and then use automation to have Access send email objects via that session.