What address (or kind of link) of the workbook you mean? Its full path on
your computer can be obtained from ActiveWorkbook.FullName. If you would like
the file to be accessed in a network or via Internet then you should add the
network address to the file name.

objMailItem.Body = ActiveWorkbook.FullName

Another way is to send the whole file, for doing this just add these lines
before sending:

ActiveWorkbook.Save
objMailItem.Attachments.Add ActiveWorkbook.FullName


" wrote:

vbapro,

Yes, that did the trick. Thank you!

Any ideas how I can attach the link to this workbook in the body text?
Is there a command that captures the address to the active excel
workbook?

Thanks for your help

//Nils