First of all thank you to the person who provided the code that I have been trying to adapt, I got it from another post on this forum.
The code I have in module 5 works to a great degree but it sends too much in the attachment.
I want to be able to click a button and send the letter only, cells J1 to R51 (not the whole sheet) it converts it to a PDF and then attaches to an email in outlook brilliantly.
I have attached a workbook for reference. The workbook will eventually have 11 sheets, so I thought I could put a button on each sheet for each letter.
Cells U6 and U7 are where the email address and subject title go
I forgot to mention that the letter sheet will be protected
Many thanks
Bookmarks