Emailing range for Excel and adding body text
 

I am trying to write vba code to send, on the click of a button, a range of
cells which exclude certain hidden colums.
I wish to sent it to an an email address which is contained in a cell
on the worksheet, and I want to be able to add text to the body of the
email, by way of a personal message.
I have used ron de bruin's examples and some code from elswhere.
So fari have managed to send the modified range, but it does not give me
the opportinuty to add text or to retrieve it from elsewhere before the
email is sent.
Can anyone help, please?
I am a novice and much of my code so far has
beed done on trial and error basis.
Peter Vaughton

Emailing range for Excel and adding body text
 

Hi Peter

http://www.rondebruin.nl/mail/folder3/mail4.htm
Download the example workbook form my site with Body examples to test

Read
http://www.rondebruin.nl/mail/tips2.htm

And use Display instead of Send so you can add your text

Post back with the exact problem you have after trying the code above


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Peter Vaughton" wrote in message ...
I am trying to write vba code to send, on the click of a button, a range of
cells which exclude certain hidden colums.
I wish to sent it to an an email address which is contained in a cell
on the worksheet, and I want to be able to add text to the body of the
email, by way of a personal message.
I have used ron de bruin's examples and some code from elswhere.
So fari have managed to send the modified range, but it does not give me
the opportinuty to add text or to retrieve it from elsewhere before the
email is sent.
Can anyone help, please?
I am a novice and much of my code so far has
beed done on trial and error basis.
Peter Vaughton