E - Mail when sheet updates - hyperlinking !

[Neil]

Hi All,

I've checked out Ron DeBruin's great site on e - mailing from excel, but need some assistance on the following.

My scenario: when an engineer updates his project log, I would like him to be able to press a button and send an alert to the review group advising them of the update.

This bit I have worked out, the macro works through a distribution list and sends a message to all in the list - great !
I have this working fine for simple (static text) messages.

What I now require assistance on is how to link to a file within the message so that the recipients can click the (hyper)link and be sent to the file.

Example:

'The project log has been updated, please check the updates now at: g:\projects\active\project1.xls.'

The hyperlink (bold example above) can be either static or retrieved by the macro from a cell within project1.xls.

How can I make this link work as a hyperlink within the body text of the e - mail message generated by the macro ?

Thanks all.

Neil

 

[Ron de Bruin]

Hi Neil

See the tips page
http://www.rondebruin.nl/mail/tips2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Hi All,

I've checked out Ron DeBruin's great site on e - mailing from excel, but need some assistance on the following.

My scenario: when an engineer updates his project log, I would like him to be able to press a button and send an alert to the review group advising them of the update.

This bit I have worked out, the macro works through a distribution list and sends a message to all in the list - great !
I have this working fine for simple (static text) messages.

What I now require assistance on is how to link to a file within the message so that the recipients can click the (hyper)link and be sent to the file.

Example:

'The project log has been updated, please check the updates now at: g:\projects\active\project1.xls.'

The hyperlink (bold example above) can be either static or retrieved by the macro from a cell within project1.xls.

How can I make this link work as a hyperlink within the body text of the e - mail message generated by the macro ?

Thanks all.

Neil

 

[Neil]

Thanks Ron,

Exactly what I was looking for...

Regards,

Neil
Hi Neil

See the tips page
http://www.rondebruin.nl/mail/tips2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Hi All,

I've checked out Ron DeBruin's great site on e - mailing from excel, but need some assistance on the following.

My scenario: when an engineer updates his project log, I would like him to be able to press a button and send an alert to the review group advising them of the update.

This bit I have worked out, the macro works through a distribution list and sends a message to all in the list - great !
I have this working fine for simple (static text) messages.

What I now require assistance on is how to link to a file within the message so that the recipients can click the (hyper)link and be sent to the file.

Example:

'The project log has been updated, please check the updates now at: g:\projects\active\project1.xls.'

The hyperlink (bold example above) can be either static or retrieved by the macro from a cell within project1.xls.

How can I make this link work as a hyperlink within the body text of the e - mail message generated by the macro ?

Thanks all.

Neil