Emailing individual documents from query or report

[BlueAxis]

Hi guys, I just joined this group, I have limited access knowledge and everything I learned about access was from youtube videos and reading online. I have only used the features that do not require coding/programming (tables/queries/reports) so please be patient with me.

Ok, this is my problem. I am the secretary of a social boat club (about 300 members) in charge of producing invoices. I created a my member table with general data, applied a query to create a Dues&Fees Table and then I created an Invoice report from this table..etc. Right now I have a final report, with 300 invoices that i could easily print and mail. However, people are asking to have their invoice emailed and I was wondering if there is a way to mass email each individual invoice to each individual member of the club. I browsed online but I cannot find a straight answer. Any help would be appreciated. Thank you in advance.

[pbaldy]

This should get you started:

http://www.granite.ab.ca/access/emai...recipients.htm

[NTC]

In a word; no - there is no easy way to split apart an Access Report into individual reports. As the link provided by pb will demonstrate - it is doable, but it is an advanced, custom implementation; not easy and typically out of the reach of casual users.

What is out-of-the-box is to generate a single customer's report (set up for Print Preview report mode), right click on it, then select Email and proceed to follow the wizard to send it out - note this presumes you use an email client on your PC and doesn't work with a browser mail such as gmail. Of course then your repeat this 300 times. Not much of an improvement over printing/collating 300 pages and stuffing them into envelopes...