C
ChuckL
I reviewed another post on this site to get an idea of how
to send an email to multiple recipients using the To:
argument in a Send Macro. It incorporated the use of a
form and a macro that selects Next Record and Repeats
count until finished. It was very helpful.
My problem now is that I need to attach a unique report to
each email. I have created a form letter (report) that
has specific controls unique to each recipient. ie:
recipients location, name. The recipient's email address
is a control on the report that is the source of the To:
argument in my Send macro. It is different on each page.
If I attach the report to the email, the entire report
(all pages) is sent to the email address on the last page
of the report. I need the first page to go to Jane Doe at
JaneDoe.com (email on page 1), second page to go to
JohnDoe at JohnDoe.com, etc (email on page 2). I need
this all to happen in one process.
Sorry for the length. I have spent most of my day on this
and I'm going nuts. Can anyone help me? I greatly
appreciate it.
to send an email to multiple recipients using the To:
argument in a Send Macro. It incorporated the use of a
form and a macro that selects Next Record and Repeats
count until finished. It was very helpful.
My problem now is that I need to attach a unique report to
each email. I have created a form letter (report) that
has specific controls unique to each recipient. ie:
recipients location, name. The recipient's email address
is a control on the report that is the source of the To:
argument in my Send macro. It is different on each page.
If I attach the report to the email, the entire report
(all pages) is sent to the email address on the last page
of the report. I need the first page to go to Jane Doe at
JaneDoe.com (email on page 1), second page to go to
JohnDoe at JohnDoe.com, etc (email on page 2). I need
this all to happen in one process.
Sorry for the length. I have spent most of my day on this
and I'm going nuts. Can anyone help me? I greatly
appreciate it.