Hello Guys!

As this is my first thread here I'd like to say that this Forum has been extremely useful for me since I joined. My boss insists on using MS Excel for some databases and I've been fighting hard in trying to automate all procedures we do as much as we can.

Recently I have deloped a code that takes a line of data from our database, transfer it to a nice looking Excel form for the revision of a group, saves this new form created at a backup location and then starts a PDF printer.

Now, I want to create an additional "Sub" that could generate an e-mail based on an Outlook e-mail template (*.oft), attaching the PDF file which has been generated by the previous macro. The PDF name is sequential and automatically generated by the previous macro as well (0001, 0002, 0003 and so on).

Anyone, any idea on how to solve it?

Thanks!