Copy data from a spreadsheet and email

[JackDanIce]

Hi,

Having difficulties finding what I want on the internet. I have a file that summaries some data which a user would copy a specified range into an email and send out. I have a macro that summaries that data but would like a macro that automatically copies the required data and pastes the values and formats into an email, which the user can then send.

In addition, I would like the email to include addressees based on address in (another) range) e.g. bob@mail.com in cell b1, kate@mail.com in cell b2

I figure the pseudo code would be something like:

Copy the required range (I have a named range for this)
Paste into a new email
Send to address in "Address range"
Stop macro, email window is open, ready for user to send

But I don't know how to code this in VBA (well the mail part mostly!)

Any help please?

 

[Jon von der Heyden]

Hi

Ron be Druins website has some useful tutorials on how to achieve this:

List of all mailer articles: http://www.rondebruin.nl/sendmail.htm

More specifically: http://www.rondebruin.nl/mail/folder2/mail4.htm

 

[JackDanIce]

Thanks Jon, but already found this site and doesn't quite help...

 

[Jon von der Heyden]

I posted the wrong tutorial. Attempt to build the routine using this as the guide: http://www.rondebruin.nl/mail/folder3/mail4.htm

I think you are more likely to get a response on the forum if you attempt to build the routine and post your code back here.