Body of an e-mail

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
How can I make copy and paste from an excel sheet to the body of an e-mail?(This with a macro).
Many thanks for help
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
I'm sorry, I don't know how to do it. However, I want to warn that it's not the best thing to do anyway. You may be using Outlook, but others may be using plain-text email programs that won't see your data the way it looks when you send it. You would be better off, perhaps, pasting it into Word, and saving it as RTF, and sending as an attachment. Wordpad can open RTF files.

Also, there is File-Send to-Email recipient. Don't choose *as an attachment* and it should put it right in there for you. Perhaps you want to find the code to do that for you rather than copy/paste.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top