View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default Mailenvelope Gives Error to Only One User

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