Send Object

[Ramu]

Hi

I am trying to send a Report through e mail, it comes as a attachmetn (Rich Text format), can anybody help me with how to copy the Report and past in the Outlook automatically.

Please

Regards
Ramu

 

[Hayley Baxter]

Are you going to be sending the same report every time? In a macro use sendobject and select your report name, output format - Richtext.

If you are going to be using a different report every time, might be better to use VBA

DoCmd.SendObject acSendReport, "RepName", acFormatRichText

There are many sample databases already on the forum.

 

[Ramu]

Thanks for the reply, I don't want to send the same report to everybody. If the report paste on the Outlook the user will select the address fron the address book.

Can please help me with the sample database in the Forum & I am very poor in VB

Regards
Ramu

 

[Hayley Baxter]

Hi Ramu

Have a look at this example provided by Bukhix. It allows you to browse for the file you need to attach and pastes this in outlook, from there you can select your mail addresses.

HTH
Hay

 

[Ramu]

Thanks for the sample database but I tried it is only attaching the file (is not pasting the content of the selected item)- please check I am be wrong.

Is there is easy example to copy a form or Report and past in Outlook? - Pls help

Regards
Ramu

 

[Hayley Baxter]

Here's a quick example, if you only need the data then this is ok using rich text format, however if you need your report to appear as it does in access you'll need snapshot format but the code would just be the same - all you would need to change is the format.