see if last macro fixes the problem at all, and if
it recurs or not.
http://www.cpearson.com/excel/clipboard.htm
If not familiar with installing macros see
http://www.mvps.org/dmcritchie/excel....htm#havemacro
paste the entire code 3 declaration then the sub... end sub
after option explicit in a new module.
If still a problem indicate your version of Excel and your operating
system and version and Service Pack level.
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Cor" wrote in message ...
I use Excel VBA to create a standard e-mail (only contains plain text). This
text is linked within Excel.
Problem is that it has been working but now only an empty e-mail is the
result. No body text only the header.
When checking the clipboard it appears that nothing is copied into it. Never
min using CTRL+C/CTR+V or via the menu !
When checking the clipboard nothing is there and still I get message "cannot
empty clipboard"
Pls advice
Cor Verheul