email attachment from MS Access

[Liz Haskin]

Hi
Can anyone help me. I need to email a report from Access as an attachment.
Because the report needs to have the company letterhead, I have used Leban's
code to create the report as a pdf. Now I need to have a button that when
clicked will create the email message (using an email address in the
database) and then attach the pdf that was just created from the My
Documents folder.
Can anyone give me some advice.
thanks
liz

 

[Guest]

Liz..

There are ways of doinmg this and I suggest you look at the options that
create a snapshot file it has an extension of ".snp" and sends a report from
within Access, another useful site to look at is "utterAccess" do a search on
this website, tons of code for e.mailing and it is searchable

Trevor

 

[SA]

Liz:

To add an attachment to a mail, you'd have to use Outlook automation to do
so using VBA. There's no internal way to do this in Access. If you want
to save time writing out the code, you might look at our PDF and Mail
Library for Access, in the developer tools on our web.