personalizing multiple emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a code that sends to all the email addresses collated in a query.
However I'd like to personalize them by including first names of people (data
which is stored on the same table as the email addresses).

This line has been suggested to me....

MyMail.Body = "Dear " & rs("FirstName") & ", " & vbNewLine & MyBodyText

This just gives me "Dear ," before the body text... any ideas?? Evidently
the 'rs' bit causes a compile error as there's an expected sub or function
thingy?
 
Hi,
how do you assing email address? you open some recordset and get it from
there? same you can use for FirstName, rs - is a variable holding recordset,
if you have it called with other name - then replace rs with name of your
recordset
 
As long as rs is set to a RecordSet object AND FirstName is a valid
field name it SHOULD work.
 
Back
Top