SendMail Function in Excel 2003 not working properly
 

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 ",
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
------------------------------------------------------------------------
JonPar's Profile: http://www.excelforum.com/member.php...o&userid=24766
View this thread: http://www.excelforum.com/showthread...hreadid=383324

SendMail Function in Excel 2003 not working properly
 

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

--
JonPa
-----------------------------------------------------------------------
JonPar's Profile: http://www.excelforum.com/member.php...fo&userid=2476
View this thread: http://www.excelforum.com/showthread.php?threadid=38332

SendMail Function in Excel 2003 not working properly
 

Hi JonPar

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JonPar" wrote in message
...

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 ",
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
------------------------------------------------------------------------
JonPar's Profile: http://www.excelforum.com/member.php...o&userid=24766
View this thread: http://www.excelforum.com/showthread...hreadid=383324

SendMail Function in Excel 2003 not working properly
 

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

--
JonPa
-----------------------------------------------------------------------
JonPar's Profile: http://www.excelforum.com/member.php...fo&userid=2476
View this thread: http://www.excelforum.com/showthread.php?threadid=38332