Thanks very much, I'm reading the information you provided..

However I need the macro to convert to PDF all the files I have in a specific folder. I have a column in my spreasheet with the name of each file, so the macro would have to do a "do-until loop" to find these files in the specified path, then get the email address that are on other column and send ithem by email.

this is what i would like to do with just one click:

Have the macro convert the files I have in column A to PDF and send each PDF file by email (using Outlook) to the specified email address.

Column A Column B
WorkbookM.xlsx Bob@hotmail.com
WorkbookT.xlsx john@hotmail.com
WorkbookE.xlsx tracy@hotmail.com
WorkbookL.xlsx Bob@hotmail.com

I have all the files in a folder on my desktop.

Thanks!
M.