Send Object to addresses in table

[cm-net]

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

[pbaldy]

This is a little overly complicated for my tastes, but it contains the basics for what you want:

http://www.granite.ab.ca/access/email/recordsetloop.htm

Check it out and post back if you get stuck.