Automatically send email with attachment.

[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.

 

[Michael Bauer [MVP - Outlook]]

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

recipients.