emailing in access 2010

[griffin.92]

hey i'm currently using access 2010 to maintain a Model UN database, i need to send a mass confirmation email to head delegates of each team about their registration, and i need to attach a report in pdf, i have executed the macro action that converts the report in pdf and sends email to one head delegate but i want to automate the process, the email ID's of the heads are mentioned in the tblhead, and the report "paymentleaflet" has a query parameter of delegation ID(primary key of tblhead), how can i create a process that will, add the email address, from the query, select the report with the delegation id paramenter, attach it send it and move to the next record, and i dont have any expirence in visual basic

[alansidman]

While this is not exactly what you are attempting to do, it might give you some ideas.

http://www.datapigtechnologies.com/f...sendemail.html

Alan

[RuralGuy]

...and my favorite email link: http://www.granite.ab.ca/access/email.htm

[NTC]

for broadcasting my approach is not to use Access.

or more correctly - I limit Access' role to gathering all the valid emails via a query. (of course making the report/pdf too...)

then one simply copy/pastes that list into one's normal email cc/bcc field, put in the message, and attach the pdf. Relying on one's email system to do the rest...

why?... 1. its simple 2. the email system is a far better place to deal with all the inevitable bounce back invalid addresses and so you have your original outbound email stored there too.. 3. it is email brand independent 4. the semi-manual aspect inherently slows the user down and I think helps make sure they don't do broadcast blasts without some forethought...

something to consider vs a totally automated solution.