Mailenvelope Gives Error to Only One User

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top