I have an excel spreadsheet which has 25 worksheets in it. Each worksheet is designed for a specific person. what I want to do is take each individual worksheet and convert to individual pdfs and then email to different people.
Sheet 1 convert to pdf and email to bob
sheet 2 convert to pdf and email to jane
sheet 3 convert to pdf and email to sam
etc
etc
the vba code i have at the moment is
The mail worksheet is as follows
Column A - name of the worksheet
Column B - the email address
Column C - the subject of email
I am totally new to all this and really need help to get it going
Bookmarks