Using VBA to send a range in pdf via e-mail

**BullseyeThor** · 03-22-2013, 11:45 AM

Hi All

I need some help with sending a sheet over e-mail using vba, however I need the range stated on the sheet to be converted and sent as PDF just by clicking on a button.

I have checked out some other sites which show solutions, however I can't get my head around making it work properly. I already use a vba code to send either a range or a sheet depending on the contents.

However I have one supplier who I send to which can't open my excel files, hence why I'm trying to look into sending as a pdf.

Thanks All

**jaslake** · 03-22-2013, 11:54 AM

Hi BullseyeThor

See this link for Code to do as you describe. If you need help adapting attach your File with existing Code.

http://www.rondebruin.nl/pdf.htm

**BullseyeThor** · 03-25-2013, 12:00 PM

Attachment 223498

Ok I had a look and it's more complicated than I thought it would be.

I just want to be able to press a button and it converts and sends to a preset address everytime. I need a range only sending as well so need to be able to select what that is.

I have attached a sample of the sheet I will be sending. I just need help with the code. I have a code which sends the sheet as an attachment in excel but the supplier apparently cannot open this and so I need to send as PDF for it to work.

Thanks in advance.