Hi roadkill
You can check out this page
http://www.rondebruin.nl/mail/problems.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"roadkill" wrote in message ...
I've provided a macro in a spreadsheet to others that automates some things
including putting up the email header using "mailenvelope". It works fine
for all but one user. The error that he receives says "Run-time error
'-2147319779 (8002801d)': Method 'MailEnvelope' of object '_Worksheet'
failed."
An exerpt from the code is as follows:
ActiveWorkbook.EnvelopeVisible = True
ActiveWorkbook.ActiveSheet.MailEnvelope.Item.to = strRecip
Any ideas what might cause this. Our references are the same.
Will