Email Snapshot as PDF

[ant1983]

Heya,

I want to email a report as a pdf and dopwnloaded the database below:

http://www.lebans.com/reporttopdf.htm

It's great for converting snapshot to PDF but, as im no programming whiz, i
cant quite figure out how to theh take this newly converted PDF and
automatically add it to an email by using the SendObject thing.

I'm sure it's just a one-liner but cant quite figure it out.

Thanks.

Wayne

 

[Daniel Pineault]

Sadly, as its name implies, SendObject is used to send Access object but
cannot send external file. So to e-mail a PDF as you wish to do, you need to
look into automating Outlook. Here are a few links that cover this subject.

http://www.devhut.net/index.php?lang=en&id=0000000013#AutoOlk
http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

If you want other option rather than Outlook (maybe be a little overwhelming
for a new programmer) take a look at

http://www.granite.ab.ca/access/email.htm - Choosing a method of sending
your email.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[Tom Wickerath]

Hi Wayne,

As long as you can create the .pdf file(s) okay, and you know what folder
they are in, you might want to try some code that I've written in the past.
You can find this code on pages 19-20 of the current copy of a Word document
that I call Access Links. You are welcome to download a zipped copy from this
location:

http://www.accessmvp.com/TWickerath/


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________