Also I forgot to mention, you could write the email-sending macro in
Outlook (where you won't get the security prompt), then (in Excel)
instantiate the Outlook Application object and call the macro from
there.


HTH,
JP


On Mar 7, 5:40*pm, IvanM wrote:
That's really helpful. *Thanks