Attach form (current record) to email.

[Jarryd]

Hi,

I have a DB that is used to create Sales/Purchase Orders. I currently print
the form (current page) and fax it to the relevant party. But I would like
to be able to attach it to an email, or even convert it to an email so that
I can send it to them from Outlook. Is this possible? Can I use the form
to create a mail item, or can I export it to a Word document so that I can
easily attach it to an email?

TIA,

Jarryd

 

[Guest]

Hi,

I have a DB that is used to create Sales/Purchase Orders. I currently print
the form (current page) and fax it to the relevant party. But I would like
to be able to attach it to an email, or even convert it to an email so that
I can send it to them from Outlook. Is this possible? Can I use the form
to create a mail item, or can I export it to a Word document so that I can
easily attach it to an email?

TIA,

Jarryd

Hi Jarryd,

You can use the SendObject method behind a button, and email form/report.
If you want to send only the current record, you may have to create a report
for the current record first and then use Docmd.SendObject to email that
report.
Look up "SendObject" in VBA Help for correct syntax and more details.

Hope this helps.

-Amit