I have an Excel file that has a macro that attaches one of the spreadsheets to an email. Everyone using this has the same version of Office/Outlook (2003). Some people can run it perfectly and other get an error '1004' - Automation Error. Can not find object. And it stops on the following line of code set OutlookMail = CreateObject("Outlook.Application").

Anyone have any ideas why this would work on some pc's but not others?

Code:
Dim OutlookMail As Object
Set OutlookMail = CreateObject("Outlook.Application")
Dim Mail As Object
Set Mail = OutlookMail.createitem(olMailItem)
 
Mail.Subject = "Accounting numbers for budget"

Mail.Display
Mail.Attachments.Add Module1.Temp