I click a button on a form which runs an append query to a table (Table1) and all this append query does is store the email addresses of the people I have selected on that form. So, if I selected Tom and John on the form, Table1 stores Tom@blank.com and John@blank.com in the first two rows of the first column. Is there anyway to take these names (note: I may also have more than 2 people selected) and set them equal to vba code people so that an email will be sent to all the persons in Table1?
strEmailAddress = Is there any code I can place here that will read all the email addresses in column 1 of Table1 so that the sendobject command will send an email to multiple people?
DoCmd.SendObject , , acFormatRTF, strEmailAddress, _
, , strSubject, strEMailMsg, False, False
Thank you for your help. Happy Holidays.
strEmailAddress = Is there any code I can place here that will read all the email addresses in column 1 of Table1 so that the sendobject command will send an email to multiple people?
DoCmd.SendObject , , acFormatRTF, strEmailAddress, _
, , strSubject, strEMailMsg, False, False
Thank you for your help. Happy Holidays.