Automating email generation with attachment included

  • Thread starter Thread starter Yann
  • Start date Start date
Y

Yann

Hello! I want to put a code behind a button on my form.
It must attach a report to an email (even better make the
report the body of the email) fill out the subject line
and send the email to an email address listed on the
form. I am using this code to generate the email:
Private Sub cmdEmail_Click()
Dim x
x = fHandleFile("mailto:" & Me!ContactEMail,
WIN_NORMAL)

I just don't know how to deal with the attachment and the
subjet line.

Thanks for your help!
 
You could use the SendObject method or action; it has arguments which allow
you to use code to specify the email address, subject and the name of the
Access report that you want to send, among others. See VBA help for further
details.

Otherwise, if you want to send a file which is not an Access object, you'll
need to look into Automation of Outlook. The following is a link with code
to create appointments, emails, and contacts - which can get you started:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/h
tml/office071299.asp

hth,
 
Back
Top