SendMail Function in Excel 2003 not working properly

[JonPar]

I have a macro that creates a copy of a worksheet, puts it in a new file
and then sends that file to a set recipient. The simple code seems to
work fine in Excel 2000, meaning it creates the copy, sends, asks the
security question, asks whether or not you want to save a copy, and
then closes that new file.

example code:

Sheets("test").Copy
ActiveWorkbook.SendMail Recipients:="(e-mail address removed)",
Subject:="test"
ActiveWorkbook.Close

But when moving to excel 2003, the same bit of code crashes the
program. I'm using microsoft outlook and the security is set to low or
med.

Any ideas on the issue?

 

[JonPar]

Sorry... I forgot one thing.

I found that the copy code works fine, it's specifically the .SendMai
code that taxes the system, even in a blank excel spreadsheet th
simplest one line of code won't send the workbook

 

[Ron de Bruin]

Hi JonPar

see
http://www.rondebruin.nl/mail/problems.htm

 

[JonPar]

Thanks, I'll check some of this sutff out. And be back...