Emailing from Access - sender

[drazen]

HI, I am setting up an email facility on my access DB, it all works fine, but theirs an annoying thing it does i would like to sort out.

The way its set up is I have client details on a form with an Email button, the button gathers info from the form and emails a 'report' to the client.

But...
The email the client gets says its from 'John Smith' I want it to say 'My Company' can this be done, if so how?

I am using the olMailItem object in Access 2010

thanks

 

[Ranman256]

you can send with 1 command:

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody

the report uses the key on the form to report only that record.

 

[Minty]

Use the SentOnBehalf property.
Note that you may need permissions in exchange for you to do this, and if you don't have the correct permission it can get "interesting" to solve.

 

[drazen]

Thanks, I think i've got the SentOnBehalf sorted