I want to automate a weekly task

S

Santi

Can the following task be automated?

On a weekly basis I have to run reports from another non office program and
save them in PDF files. After doing this I have go to outlook and attach each
of these files into four different type of distribution lists and send them.
As you can see this is a very time consuming task that I have to live with
not to talk about boring. Anyways, is there anyway to automate this process?
If so I would really appreciate any assistance.
 
J

JP

You could run the other program and save the PDF files with a
recognizable name into a single folder, then have a macro loop through
a folder containing the files, and, depending on the filename, create
the email and attach the file and send it.

There are lots of sites with freely available code that can assist
you, such as:

http://www.rondebruin.nl
http://www.outlookcode.com


HTH,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

outlook schedule task (macro) to run weekly. 1
How do I automate regular "reminder" emails from Outlook 2003 4
Dialog box to select existing task 1
Code to move task from inbox to a task folder 3
Macro to remove contact from multiple distribution lists? 0
Automate Task scheduler password change 2
Automate Combine 2 Spreadsheets into two worksheets 5
How can I automate copying data from one into several spreadsheets 2

Top