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?