How to convert multiple excel files from a given location to PDF and send by email

Hello,

I'm new in VBA and macros, i have just done an easy project using help from this forums and from internet but now i need some help with a more complex task.

I have different excel workbooks, each with 2 or more tabs, and I want all these excel files from a specific location to be converted to PDF format (no opening them), not to a single PDF, but each excel file to its own PDF and then send each of them by email to different recipients. I would have a column to match each file name with the recipient's email or name.

I have excel 2007

Thanks very much!
M.

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 [email protected]
WorkbookT.xlsx [email protected]
WorkbookE.xlsx [email protected]
WorkbookL.xlsx [email protected]

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

Thanks!
M.