Automatically send email with attachment.

  • Thread starter Thread starter Chaniacreta
  • Start date Start date
C

Chaniacreta

Our company publishes on the web a report every week as pdf file with a fixed
file name. Such as www.mycomp.com/report.pdf . I send a copy of the report
to certain clients every week for the records since it is over written. I
would like to automate this task so that every week at the same the same time
an email is sent with the file attached. I realize that this has two parts
1) creating the email with the attachment and 2) sending it. Part 1) is more
critical in that I could use a reminder to prompt me to send it. I'd like a
macro to create the email, attaching the file and selecting the recipients.
 
See the functions CreateItem, Attachments.Add, and Recipients.Add

This sample demonstrates how to utilize a task reminder for sending an
e-mail automatically:
http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=10&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Fri, 30 Jan 2009 12:52:12 -0800 schrieb Chaniacreta:
Our company publishes on the web a report every week as pdf file with a fixed
file name. Such as www.mycomp.com/report.pdf . I send a copy of the report
to certain clients every week for the records since it is over written. I
would like to automate this task so that every week at the same the same time
an email is sent with the file attached. I realize that this has two parts
1) creating the email with the attachment and 2) sending it. Part 1) is more
critical in that I could use a reminder to prompt me to send it. I'd like a
macro to create the email, attaching the file and selecting the
Click to expand...
recipients.
 
Back
Top