e-mail code

M

Maurice

Instead of the hardcoded emailadresses refer to the controls on the form that
should do the trick.

So:

40 DoCmd.SendObject acSendReport, "Report1", acFormatPDF,
me.textbox;me.textbox2; me.textbox3, , me.textbox4, "Test Resutls", "Attached
are
your results for Report ID - "

ofcourse you replace the me.textbox for the textbox names you are using.
 
B

Beeyen

Good Day Mr Maurice,

I would like to include the names from two different combo boxes with drop
downs into the To: field and add information from a field on the main form
into the body of the email. Would you know how this can be accomplished?

Maurice said:
Instead of the hardcoded emailadresses refer to the controls on the form that
should do the trick.

So:

40 DoCmd.SendObject acSendReport, "Report1", acFormatPDF,
me.textbox;me.textbox2; me.textbox3, , me.textbox4, "Test Resutls", "Attached
are
your results for Report ID - "

ofcourse you replace the me.textbox for the textbox names you are using.
--
Maurice Ausum


rml said:
I'm using the below code to create an e-mail. It works fine. What I would
like to do is have the e-mail address/s pull from a field/s on the form.
[emailfield]

Can someone show me the code? Thanks.

40 DoCmd.SendObject acSendReport, "Report1", acFormatPDF, "[email protected];
[email protected]; [email protected]", , "[email protected]", "Test Resutls", "Attached are
your results for Report ID - "
Click to expand...
Click to expand...
 
Top