Excel, Macro designed to send mails via Outlook : question on certificate

[Daniel]

Hi everybody,

I created in Excel a macro designed to send specific mails via Outlook.

Because an Outlook dialog box asked me all the time whether I authorize the
transmission or not, I created a certificate using MS Office "SelfCert".

So far so good. My macro is signed.

However, Outlook keeps on asking me everytime to authorize the transmission
of the mails.

What should I do / check ?
Anybody ?

Many thanks in adavance for your time and kind help.

Daniel

 

[Gord Dibben]

Everything you wanted to know about sending emails fro Excel using Outlook.

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


Gord Dibben MS Excel MVP

 

[Daniel]

Many Thanks, Gord.
I do appreciate your help.
Brgds,
Daniel

 

[ilia]

Check out this:

http://www.contextmagic.com/express-clickyes/

And this:

http://www.excelguru.ca/node/44

I've worked with this before, it does the trick. The only issue is
having the app installed and running.

 

[Daniel]

Thanks a lot Ilia.
Most useful.
With best regards,
Daniel

"ilia" <[email protected]> a écrit dans le message de (e-mail address removed)...
Check out this:

http://www.contextmagic.com/express-clickyes/

And this:

http://www.excelguru.ca/node/44

I've worked with this before, it does the trick. The only issue is
having the app installed and running.