Use

http://www.rondebruin.nl/mail/folder1/mail4.htm

Or
http://www.rondebruin.nl/mail/folder2/mail4.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vic1" wrote in message ...
Thanks. That helps. I'm almost there apart from one thing - in spite of
inserting the correct cells in the range, my email attachment is returning a
copy of the whole worksheet, not just the selected cells.

What am I doing wrong?

"Ron de Bruin" wrote:

Hi vic1

Click on the Tip link on each example page



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vic1" wrote in message ...
I've spent hours on the www.rondebruin.nl Tip on sending emails from Excel.
They're brilliant - but I'm a total newbie to VBA and what I need is a
combination of two of his options - and, try as I might, I cannot combine
them successfully!
I need to email a range from within Excel to an email address contained
within one of the cell values.

I've successfully got one macro which will send to the right address - but
only with a 'fixed file path' attachment, so it doesn't send a copy of the
current page, only a previously saved pdf. Which bits of the code for sending
a range do I need to copy into my existing macro, and where? I've tried the
sendmail add-in - but it doesn't automatically fill in the relevant email
address.

I'm sure this is simple to someone who knows what they're doing! Please can
you help me out?