Hi CLR

Sorry I never used Notes so I can't help you
You can check out Dennis his site, maybe you find info there.
http://www.excelkb.com/?cNode=1X5M7A

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message ...
Hi All.......
I'm using a modified version of Ron DeBruin's email code to send portions of
a sheet to vendors. The sheet is all calculated against cell A1 which is
the Vendor code...all other info is looked up on the database and or
calculated.......I just set a vendor number in A1 and press the
button.....all's well, the email goes out and control returns to Excel 2k,
however.........when I make another macro to feed numbers in to A1 and then
call my email routine, to send multiple emails, it sends the first one fine,
then locks up in Lotus and does not return control to Excel so I can put
another vendor number in A1.........

If I insert a msgbox between the snippets for each Vendor number it works
fine, but then I must manually OK the msgbox before the code will
continue.......I would rather it all ran automatically.......

Any ideas about how to return control to Excel? Just selecting a sheet, or
cell don't do it.
TIA

Vaya con Dios,
Chuck, CABGx3