Sending Personalized Email from Excel

[Konji]

Hi,

I am using for a long time the macro developped by our guru
J-Walkenbach available thru the URL
http://www.j-walk.com/ss/excel/tips/tip86.htm

Our company was upgrated in Outlook 2003/Excel2003, and this usefull
macro doesn't partially work anymore : the sending process was stopped
as if the sendkeys instruction was not accepted by Outlook2003.

Has someone faced such issue ? and what was the solution ?

Thanks for your help.

 

[raymond.allan]

Hi,

Goto Ron De Bruin email page, he is the guro for this

http://www.rondebruin.nl/sendmail.htm

Raymond

 

[Konji]

Hi Raymond,

That's what I have done.
For using Ron's development, I need to re-think my work...
What I am looking for is a quick solution (if any) based on J-Walk.
macro because I am in an uregency.
Anyway, thanks for your advice.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/mail/folder3/message.htm

 

[Konji]

Dear Ron and Raymond,

I have found the issue !
Our IS has upgraded Office product in the country language (not
English...).
So the sendkeys item must be adapted in the macro following the key
used in the language of the application.
Another way is to switch again to English, what I have done.

As I am using Ron's file in another process, I will adapt all my
processes by using it.
Thanks for this nice and usefull tools.