I want to automate a weekly task

  • Thread starter Thread starter Santi
  • Start date Start date
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.
 
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
 
Back
Top