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

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