-----Original Message-----
Peter,
Make a form based on the table or query that contains your email
addresses.
Make a macro using these actions:
SendObject
GoToRecord , Next
In the To argument of the SendObject, put the equivalent of...
=[Forms]![NameOfYourForm]![NameOfEmailAddressControl]
Then make a second macro, with these actions:
GoToRecord , First
RunMacro , Name of first macro.
In the Repeat Count argument of the RunMacro action, put 10. This
assumes there will always be 10, otherwise you need to put an
expression that counts the number of records.
Well, an incomplete answer, but hope that helps to point you in the
right direction.
- Steve Schapel, Microsoft Access MVP
If I have eg 10 email addresses in a table/query - How do
I use a query/macro to send individual separate emails to
those addressees?
.
