Copy data from a spreadsheet and email

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,696
Office Version
  1. 365
Platform
  1. Windows
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?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,696
Office Version
  1. 365
Platform
  1. Windows
Thanks Jon, but already found this site and doesn't quite help...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,121
Messages
5,570,307
Members
412,318
Latest member
angoeyuan
Top