Email Macro Creating .tmp Files on Some Computers

[Shiremaid]

I am using Ecel 2007.
In the workbook I am having a problem with, the users need to be able to send just the one sheet to our purchaser instead of having to send the entire (and rather large) workbook.

I've been using the following code

Sub Email3()
'
' Email3 Macro
'
'
Sheets("Quote Request").Select
Sheets("Quote Request").Copy
ActiveWorkbook.SendMail Recipients:="fake@notreal.com"
End Sub

And it works fine for everyone except one foreman. The first time he hits the button it opens the email program and attaches a .tmp file instead of the .xlsx the rest of us get.
It will work if he pushes it a second time. But I would like to get it working for him the first time if I can.

Thanks

 

[Shiremaid]

Further Information

We have figured out through playing with it that if he has already created a Book 1 with Excel it will go to Book 2 and work fine the first time he clicks.

But he's still the only one it's happening to, everyone else can send the sheet just fine if it gets created as Book 1

 

[Shiremaid]

anyone know what this happens?