Email Multiple Users

[Kurt]

Hi, Lets start by saying I'm rubbish with access!, I'm trying to create a
button that will email a report as a pdf to a list of people which have
registered to recieve the particular report.

I have used the sendobject but I'm stuck on the "to" option, I need to get
my emails a querie which filters the people from the open form. Is it
possible to do?

My form is "events", the report is called "EventReminder", the querie that
only shows peoples emails that have registered for the current form data is
"SendEventReminder"

 

[Tony Toews [MVP]]

Hi, Lets start by saying I'm rubbish with access!, I'm trying to create a
button that will email a report as a pdf to a list of people which have
registered to recieve the particular report.

I have used the sendobject but I'm stuck on the "to" option, I need to get
my emails a querie which filters the people from the open form. Is it
possible to do?

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Dhony Merapendra]

ok, I join now ? help me to registrated ?