G
Gina
This is a tough one.
I have a database which creates a letter with multiple companies attached.
When I sent the letter to a report in MS Access each page in the Access
report is addressed to a different recipient selected from my database.
I would like to email theses letters to the appropriate recipients. I'm
able to retrieve the email addresses for the selected recipients and insert
them into the email, however I don't want the recipients to see all the
letters, only the one addressed to them.
Is there a way of splitting the report database so that an email is created
for each recipient showing the letter addressed to them.
Gina
I have a database which creates a letter with multiple companies attached.
When I sent the letter to a report in MS Access each page in the Access
report is addressed to a different recipient selected from my database.
I would like to email theses letters to the appropriate recipients. I'm
able to retrieve the email addresses for the selected recipients and insert
them into the email, however I don't want the recipients to see all the
letters, only the one addressed to them.
Is there a way of splitting the report database so that an email is created
for each recipient showing the letter addressed to them.
Gina