email automation with vba in access2003, need to automate "From"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,
I want to sent an email with an attachment by using docmd.sendobject. All is
fine, but I also must include the "from"-field. How can this be done. I don't
see this option in the SendObject method. Is there a way around this problem.
Peter
 
There is no such option. SendObject will always use the current user's default account. Whether you can get control over the send account if you use Outlook objects instead of SendObject depends on your version of Outlook and other factors. See
http://www.outlookcode.com/codedetail.aspx?id=889 for various approaches that might fit your scenario.


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Tnx a lot Sue,
I will have a go at the various options. See if I can get it to work. Keep
you posted.
Pampers
 
Back
Top