Adding range to body of email and attach pdf

[davidathoegh]

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.

 

[Armando Montes]

This can help:
http://www.rondebruin.nl/sendmail.htm

 

[davidathoegh]

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]

Hi

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