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

  • Thread starter Thread starter amorrison2006
  • Start date Start date
A

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
 
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.
 
Back
Top