Email customised reports in PDF to different recipients

[melwheels]

We have several hundred individuals in our database. We want to email
them a PDF copy of a customised letter. This letter is a report, which,
when opened "as is" includes all the records in it. The details of the
names/emails of these individuals are in a table in the database.

I have looked and researched the issues and this appears to be the most
complexe set of functions to patch together I've come across. In fact,
I don't know how to put everything together. I believe I need to:

- Cycle through the records to generate individual reports

- Print/save each of these individual reports to a pdf file,
customising the name of each to reflect the recipient's name

- Generate individual emails by cycling through the emails table.

I've found a few pages that discuss the different parts of this, but
either they seem very old, or they are simply *way* above my head.
Sample code found doesn't seem to make a lot of sense to me,
particularly not when comes time to actually tie everything together.

I would appreciate any help you could provide (and I recognise I may
very well be beyond help ).

Links I found and am looking at/studying:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=35321&lngWId=1

http://groups.google.com/group/comp...ast_SpamBegone_.net&hl=en&lr=&c2coff=1&rnum=1


http://www.granite.ab.ca/access/email/reportsasattachments.htm

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Thanks

Mel

 

[melwheels]

Anyone?

 

[Guest]

Mel
Stephen Lebans has code to convert a report to a pdf file on his Web site
and Tom Wickerath has code to send attachments to e-mails but the code is
quite complicated.

However, I have combined their code into a module which can be imported into
a database and then called with one sub-routine call. You just pass the name
of the report, the e-mail address/es, the Subject field text and the Body
test
to the routine and the code converts the report to a pdf file, attaches it to
the e-mail and then passes it to the e-mail client program. If you would like
a copy just e-mail me, my e-mail address is in my Profile.

 

[melwheels]

Thank you Peter,

I'll drop you an email in a moment.

Mel