P
PAkerly
Hello,
I want to email an access report.
However my report consists of many pages and not all pages go to the
same recipient.
For example I have a report that looks like this.
-----
Welcome to the club, %name%.
Thank you for joining and I hope that you find this club useful.
Your Welcome packet will be emailed next week. However in the
meantime,
I would like to make sure we have the correct information for you.
email address: %useremail%
We will be sending the email to this address. If it is not correct
please contact us.
-----
So the report is generated based on a query. I would like to send
each page to the
%useremail% email address.
And to make it more efficient, if there is more than one page with the
same email address,
send all pages om the same email. Maybe as .rtf attachments.
my report is called reportClubWelcome
Any idea if this can be done easily? Any help would be greatly
appriciated, very new to this.
I want to email an access report.
However my report consists of many pages and not all pages go to the
same recipient.
For example I have a report that looks like this.
-----
Welcome to the club, %name%.
Thank you for joining and I hope that you find this club useful.
Your Welcome packet will be emailed next week. However in the
meantime,
I would like to make sure we have the correct information for you.
email address: %useremail%
We will be sending the email to this address. If it is not correct
please contact us.
-----
So the report is generated based on a query. I would like to send
each page to the
%useremail% email address.
And to make it more efficient, if there is more than one page with the
same email address,
send all pages om the same email. Maybe as .rtf attachments.
my report is called reportClubWelcome
Any idea if this can be done easily? Any help would be greatly
appriciated, very new to this.