Lookup email address from table using order number then send Email.......

[amorrison2006]

Hi there,

I have tables which are linked by a relationship. I am sure I have
the relationships setup correctly.

One of my tables contains contacts email address and then linked to
them is orders.

On my main form I have a check box which will eventually be setup to
send an email from outlook.

I do not know how to get the correct contact for my account......to
send the email.

I would I get a macro to lookup the correct email address???

This is so confusing for me,

I appreciate anyones help,

Thanks so much in advance,

Andrea

 

[jahoobob via AccessMonster.com]

If you have the email field on your form you can use a command button to send
an email by placing cimilar code in the button's On click event:
strEmail = Me.email
stDocName = "invoice"
DoCmd.SendObject acReport, stDocName, "RichTextFormat(*.rtf)", strEmail,
"", "", "", "", False, ""
This will email the report named invoice to the contact.