Home » Forums » Open Source Learning Center » Question and Answer

VBA code to generate mail with the hyperlink of Active workbook

Submitted by arclite123 on 17 February, 2011 - 10:34

i need a macro to implement a button which when pressed, will send a mail via outlook to a specified person with the path/ hyperlink of the current/active workbook (which is placed in a project server). Please Help me with this.

‹ Wants to automate my report Zip files from excel ›
»
Nick's picture

email workbook path

Submitted by Nick on 17 February, 2011 - 14:00.

check out this tip:

excelexperts.com/Outlook-Email

with the "Body" field, use:  Thisworkbook.path

.. it won't be a hyperlink, but they can copy and paste it into explorer

 

 

 

 

»

  Hi Nick Is there any way i

Submitted by arclite123 on 18 February, 2011 - 07:11.

 

Hi Nick

Is there any way i can include the hyperlink of current workbook in the subject or body of mail?

»

hyperlink

Submitted by Anonymous on 20 February, 2011 - 20:21.

try wrapping the text in some basic HTML..

»