I have a VBA application which requires the same workbook
to be sent (using sendmail) to multiple recipients, one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel crashes
when it tries to process sendmail for the second time.
This problem only arises where the sendmail loop appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform, putting in
a delay between sendmails, putting the userform.show into
a different module. The problem occurs even if I show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?

Hi Bernard

Do you use Outlook or Outlook Express

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


"Bernard Foot" wrote in message ...
I have a VBA application which requires the same workbook
to be sent (using sendmail) to multiple recipients, one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel crashes
when it tries to process sendmail for the second time.
This problem only arises where the sendmail loop appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform, putting in
a delay between sendmails, putting the userform.show into
a different module. The problem occurs even if I show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?

Hi, Ron.

Amazingly, I've already sent you an email about this, as
everywhere I looked on the web I saw your name!

I'm using Outlook 2000, Excel 2000, and WinXP Pro.

Regards,

Bernard.

-----Original Message-----
Hi Bernard

Do you use Outlook or Outlook Express

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


"Bernard Foot"
wrote in message news:2522601c4602e$26826b60
...
I have a VBA application which requires the same
workbook
to be sent (using sendmail) to multiple recipients, one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel crashes
when it tries to process sendmail for the second time.
This problem only arises where the sendmail loop
appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform, putting
in
a delay between sendmails, putting the userform.show
into
a different module. The problem occurs even if I show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?


.

There is a Bug in Outlook

http://www.rondebruin.nl/mail/problems.htm
Try number 4

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


wrote in message ...
Hi, Ron.

Amazingly, I've already sent you an email about this, as
everywhere I looked on the web I saw your name!

I'm using Outlook 2000, Excel 2000, and WinXP Pro.

Regards,

Bernard.

-----Original Message-----
Hi Bernard

Do you use Outlook or Outlook Express

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


"Bernard Foot"
wrote in message news:2522601c4602e$26826b60
...
I have a VBA application which requires the same
workbook
to be sent (using sendmail) to multiple recipients, one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel crashes
when it tries to process sendmail for the second time.
This problem only arises where the sendmail loop
appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform, putting
in
a delay between sendmails, putting the userform.show
into
a different module. The problem occurs even if I show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?


.

Ron,

Your item 4 is:
========================
Because there is a bug in Outlook it is possible that you
must uncheck
"send immediately when connect" in the Outlook options.
ToolsOptionsMail Setup in the Outlook menu.
=====================

Perhaps this is not for Outlook 2000? If I go into
ToolsOptions I do not see a Mail Setup choise.

I get Preferences/E-mail/E-mail options and Mail
Services, but I cannot see the "send immediately when
connect" setting.

Berni.


-----Original Message-----
There is a Bug in Outlook

http://www.rondebruin.nl/mail/problems.htm
Try number 4

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


wrote in message
...
Hi, Ron.

Amazingly, I've already sent you an email about this,
as
everywhere I looked on the web I saw your name!

I'm using Outlook 2000, Excel 2000, and WinXP Pro.

Regards,

Bernard.

-----Original Message-----
Hi Bernard

Do you use Outlook or Outlook Express

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


"Bernard Foot"
wrote in message news:2522601c4602e$26826b60
...
I have a VBA application which requires the same
workbook
to be sent (using sendmail) to multiple recipients,
one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel
crashes
when it tries to process sendmail for the second
time.
This problem only arises where the sendmail loop
appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform,
putting
in
a delay between sendmails, putting the userform.show
into
a different module. The problem occurs even if I
show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?


.



.

Hi Bernard

I have open a Virtual PC to check it and Outlook 200 have this setting in
ToolsOptionsMail Delivery

Post your code if this is not working

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


"Bernard Foot" wrote in message ...
Ron,

Your item 4 is:
========================
Because there is a bug in Outlook it is possible that you
must uncheck
"send immediately when connect" in the Outlook options.
ToolsOptionsMail Setup in the Outlook menu.
=====================

Perhaps this is not for Outlook 2000? If I go into
ToolsOptions I do not see a Mail Setup choise.

I get Preferences/E-mail/E-mail options and Mail
Services, but I cannot see the "send immediately when
connect" setting.

Berni.


-----Original Message-----
There is a Bug in Outlook

http://www.rondebruin.nl/mail/problems.htm
Try number 4

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


wrote in message
...
Hi, Ron.

Amazingly, I've already sent you an email about this,
as
everywhere I looked on the web I saw your name!

I'm using Outlook 2000, Excel 2000, and WinXP Pro.

Regards,

Bernard.

-----Original Message-----
Hi Bernard

Do you use Outlook or Outlook Express

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


"Bernard Foot"
wrote in message news:2522601c4602e$26826b60
...
I have a VBA application which requires the same
workbook
to be sent (using sendmail) to multiple recipients,
one
at a time. (The VBA loops through a list of users,
amending the workbook before each mailing.)

The first recipient mailing works OK, but Excel
crashes
when it tries to process sendmail for the second
time.
This problem only arises where the sendmail loop
appears
after a userform.show in the same module. I've tried
using both userform.hide and unload userform,
putting
in
a delay between sendmails, putting the userform.show
into
a different module. The problem occurs even if I
show a
userform with absolutely nothing in it, and just
terminate the form.

Any ideas?


.



.