Access Form To Populate Outlook Email Address

[JohnPeasley]

I'm using an Access form to populate an Outlook email template. I have been successful getting the data from the form into an email using this sequence Body = Replace(Body, "@1", Me.[BUREAU CODE]) with a control source tied to a specific table or query.

My problem is one of my form fields uses =dlookup to populate the form and I don’t know how to tell Access to take that field and put it in the email To address.

 

[isladogs]

Save the dlookup result as a string.
Use the string in the To field

 

[Ranman256]

you can put the email in a text box (on the record), or cycle thru a list of them using a listbox.

DoCmd.SendObject acSendReport, "rMyReport", acFormatPDF, txtBoxEmail, , , "Subject",

 

[JohnPeasley]

I only needed to add one line: objOutlookMsg.To = Me.[Text113]