Emailing a report with outlook

[grassbladeacc]

Hi everybody,
I am using access 2010 outlook 2010. Running a small business. I would like to email a report such as an invoice to a customer via ms outlook. The invoice contains the customers email address. What I do not want is to retype the email address in the outlook message window. The email address should automatically appear in the "To" field of outlook new message window. Can it be helped?
Regards
:banghead:

 

[mahenkj2]

Try docmd.sendObject

DoCmd.SendObject acSendReport, "report1", , [From]

If you call this report from a form, then do you have customer name at form. Then you can reference customer name in place of [From]

When you type docmd.sendobject, intellisense shall start helping you.

best regards.

Edit: Sorry, customer email at [From].