Possible to copy and paste to a new outlook msg?

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

Is it possible to create a macro to copy the info from a
few specific cells, create a new outlook message and
paste the copied info into the new message?

Thanks.
 
Hi Derrick,
Take a look at John Walkenbach's

Sending Personalized Email from Excel, John Walkenbach, Tip 86, Using Outlook
http://www.j-walk.com/ss/excel/tips/tip86.htm

Mail Merge - Without Word, John Walkenbach, Tip 92, in Excel, of course. (This is the one with the Elephant -- Elephants R Us).
http://www.j-walk.com/ss/excel/tips/tip92.htm

You could also do this with a hyperlink, but may run into
problems with length. You will probably see that some
characters are substituted for in John's macros.

A1:E1 -- to:, subject:, value1, value2, send
A2: (e-mail address removed), (e-mail address removed)
B2: For your information
C2: '$1,000.00
D2: '$814.74
E2: =HYPERLINK("mailto:" & A2 & "?subject=" & B2 & "&body=" &
"You have paid " & C2 & " and still owe " & D2, "[mail]")

If you want cc and bcc you can generate
mailto:xyz?cc=xyaa&subject=xyab&body=xyac

=
 
Back
Top