Using a Hyperlink to send email

Hello LLori998,

Since you are using a Hyperlink to connect with the default email program, you are limited to what you can do. Attachments have to be done by a macro. There is a way around the security issue with email. Rather than using the MailTo protocol, you can send attachments without a security warning by using Collaborative Data Objects or CDO. Click the link below to learn about it.

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

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello LLori998,

Since you are using a Hyperlink to connect with the default email program, you are limited to what you can do. Attachments have to be done by a macro. There is a way around the security issue with email. Rather than using the MailTo protocol, you can send attachments without a security warning by using Collaborative Data Objects or CDO. Click the link below to learn about it.

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

Sincerely,
Leith Ross

Thanks for the reply - so basically the only way around this is to use a macro? The security settings on the majority of the employees will require them to chang their macro security... which will cause issues. the employees get the macro security warning as soon as they open the document, not after they click on the macro.

ugh

Correct.

To send an email with an attachment would require use of VBA in Excel.

The previous poster was also saying that you will find that if using Outlook - when you try and control Outlook with it's own Object model from Excel you will get security warnings in Outlook (as something is trying to control it remotely) -- by using CDO method as opposed to Outlook Object in Excel VBA you can avoid the Outlook security warnings.

However going back to your original point - you will need to use Excel VBA to generate an email with an attachment... if you believe this is not viable for you then you are I'm afraid stuck.

If you change your security settings to Medium, close XL and re-open are the security settings reset to High ?

hello,

thanks for the response... no, once the security settings are reset, there are no issues with it going back to high... .however, to teach 3500 call center, field guys how to do that... might be 'not worth the time'.

it's prolly easier to tell them how to save and send an attachment.


thanks for the help!

Lori