Possible to copy and paste to a new outlook msg?

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.
 
D

David McRitchie

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: [email protected], [email protected]
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

=---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top