Using Mapi to send emails in VBA - Help pls
I am building 2 applications (1 Access, 1 Excel) which use MAPI functionality to send emails.
Everything works fine and the VBA routine loops through my recordsets, creates emails, attaches files and sends the emails off. brilliant.
One problem - I demonstrated the apps to the customer today and everything is fine except that when people open the emails, she wants them to appear as if they have been sent from a different mailbox. I.e. she is logged on to her account (say, Rachel Green), she also has full permissions for another mailbox called CST Customer Reports. She send emails from this mailbox by using the FROM field in Outlook. Can I do this through the MAPI VBA? I can't find any settings that will allow me to set this property.
Any help greatly appreciated