Adding range to body of email and attach pdf

davidathoegh

New Member
Joined
Oct 6, 2010
Messages
16
Hi all,

I have a named range in my file which I wish to add to the body of my email, at the same time I want to attach that range as a pdf file (under one code to automate the process).

I have used online tutorials and have managed to add the range to the body of the email and have also attached the pdf in seperate macros...i am just unable to do them together, as my level is very basic.

Any help would be greatly appreciated.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

davidathoegh

New Member
Joined
Oct 6, 2010
Messages
16
thanks for your reply,

i have used that site to send a range in the body of an email, and have also used the tutorial to send the range as a pdf attachmen - both of which were sucessful. My issue is still to combine the two, so the email has the range as the body of the email and as a pdf attachment.

any other advice would be greatly appreciated.

thanks
 

Ron de Bruin

Board Regular
Joined
Aug 1, 2006
Messages
234
Platform
Windows, MacOS
Hi

Mail me private and I send you a example workbook today or tomorrow.
You will find my mail address on my site
 

Watch MrExcel Video

Forum statistics

Threads
1,099,622
Messages
5,469,758
Members
406,668
Latest member
ElizaR

This Week's Hot Topics

Top