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:="test.test@test.com", 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 .SendMail code that taxes the system, even in a blank excel spreadsheet the simplest one line of code won't send the workbook.

[Ron de Bruin]

Hi JonPar

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

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


"JonPar" <JonPar.1reoz2_1120079204.2159@excelforum-nospam.com> wrote in message
news:JonPar.1reoz2_1120079204.2159@excelforum-nospam.com...
>
> 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:="test.test@test.com",
> 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
>

[JonPar]

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