>How do I copy an entire worksheet in Excel to the clipboard and then paste it into the text of an email message?
>
>Background: I have an daily overnight task which creates two grids, exports them to Excel (including background colors), saves the Excel spreadsheets and then sends an email (using CDO) to some mgmt folks with the two Excel spreadsheets as attachments. This has been working fine.
>
>While on vacation without laptop, the owner of the company learned that while he could read email almost anywhere in the world, he couldn't necessarily open the spreadsheets. The solution, which I've been doing manually for the last week, has been to open each spreadsheet, do Ctrl+A then Ctrl+C to copy the entire spreadsheet to the clipboard, and then to paste it from there into the text of the email. (Note that this includes the pretty background colors.) I could easily continue to do so manually each day for the next two weeks until he returns from vacation.
>
>However, the other recipients have now indicated that they much prefer to see the spreadsheets embedded into the email message, rather than attachments, so I'll need to automate the process.
>
>Any ideas?
>
>TIA
I would probably start from
Re: Com and Clipboard Thread #
865717 Message #
865870or
Re: Copying text from word to VFP Thread #
709059 Message #
709952
If it's not broken, fix it until it is.
My Blog