Insert Hyperlink And Send Email

Hi All

The macro below works fine, but it attaches a file to the email. What I would like to do is send a hyperlink instead of sending the attachment.

Please Login or Register  to view this content.

Any help would be appreciated as I dont really know much about macro's.

Thanks

Shahid_Excel

Hi John

Thanks for the below.

However what this gives me a hyperlink on the email to www.cnn.com, and what i woudl like here is to pickup the current path of the active workbook.

Also I would like to just send the email rather than open any outllok message coming up on the screen.

I would be greatful for any help.

Thanks

Shahid

Hi John

Almost there it all works but the link only opens the folder M:\NEW_ORDER_SHEETS\PENDING_SHEETS it does'nt open the excel workbook.

Thank you

Shahid

Hi John

Managed to figure it out now sorry I am new to macros.

Thank you for your help.

Shahid