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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 23 Oct 2007 22:46 GMT

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

Reply to this Message

Gord Dibben - 23 Oct 2007 23:55 GMT

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

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

Gord Dibben MS Excel MVP

>Hi everybody,
>
[quoted text clipped - 14 lines]
>
>Daniel

Reply to this Message

Daniel - 24 Oct 2007 11:45 GMT

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

> Everything you wanted to know about sending emails fro Excel using
> Outlook.
[quoted text clipped - 23 lines]
>>
>>Daniel

Reply to this Message

ilia - 24 Oct 2007 16:03 GMT

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.

> Many Thanks, Gord.
> I do appreciate your help.
[quoted text clipped - 33 lines]
>
> - Show quoted text -

Reply to this Message

Daniel - 24 Oct 2007 17:46 GMT

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

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.

On Oct 24, 6:45 am, "Daniel" <notmyrealaddr...@wanadoo.fr> wrote:

> Many Thanks, Gord.
> I do appreciate your help.
[quoted text clipped - 38 lines]
>
> - Show quoted text -

Reply to this Message