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

Daniel · Oct 23, 2007

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 · Oct 23, 2007

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

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

Gord Dibben MS Excel MVP

Daniel · Oct 24, 2007

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

ilia · Oct 24, 2007

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 · Oct 24, 2007

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.