Hello,
I'm trying to use the Send Object command in a macro to send order confirmation emails to my customers. The body of the email will be the same for all addresses but the subject should have the PO number of the respective customer and his address only. The table that has the email address and PO number would look something like this:
Customer Name PO Number Email Address
Bob 12345 bob@email.com
Tim 12346 tim@email.com
Lucy 12347 lucy@email.com
Is there any way to get a single access macro to send 3 different emails using the same message body but with email subjects that look like this:
Subject: Your PO 12345 has been received (to Bob)
Subject: Your PO 12346 has been received (to Tim), etc.
Thanks in advance for your time!
c