Sending email with attachment with HYPERLINK

[Berry]

Dear all,

Who can help me with my problem:

I have multiple email addresses linked together: =HYPERLINK("Mailto:
"MULTIPLE EMAIL ADDRESSES") , so when clicking the link, outlook open
a new message to these email addresses.

My question: How can I click the link, and outlook opens a new message
with this workbook?

And is it possible to transfer any email addresses automaticly into a
CC (in stead off TO)

Looking forward to solutions.

Cheers BL

 

[Ron de Bruin]

You need a macro if you want that

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

Click also on the Tip link that you see on each example page

 

[Berry]

Hi Ron,

Nice site!! Really helped me out.

Just have another question:
In the same workbook I have also mail adresses linked together with:
=HYPERLINK("Mailto: "&L37,"Email all")
I just want, when clicking "Email all" sending a message in BCC to
those email addresses.

Do you know how I can send it into BCC in stead of TO?? Or do I need a
macro for this also?

Best regards,
Berry

 

[Ron de Bruin]

Hi Berry

See
http://support.microsoft.com/kb/916858/en-us