email a report

[srideout2525]

basically i have a report( an invoice) for a client. is there a way to email the report so i can skip printing and faxing it I've tried but it simply sends a messed up html page.

any help?

 

[Fizzio]

The easiest way is to use the docmd.sendobject method in VBA but this will lose the formatting of the report (ie borders etc) and it is not the most reliable way. Search the forum here for e-mail or email and you will pull up a lot of answers and search help for use of the SendObject method.

A better way is to use the Outlook object (there are plenty of examples in this forum)

 

[Hayley Baxter]

Have a look at the first example in this thread