R
roadkill
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
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