customize email title

[Anders]

Hi all,

Easy one - aren't they all coming from me

I have an email command that I'd like to customize the title of the email to
the name of the document...

..subject = ??

'activeworkbook.fullname' worked but was just too long as it gave the whole
string.

TIA

 

[Ron de Bruin]

See the code examples on this page
http://www.rondebruin.nl/sendmail.htm

 

[Rick Rothstein]

Does ActiveWorkbook.Name give you want you want?

 

[Ron de Bruin]

I see now that you want this

Thisworkbook.Name

Or
ActiveWorkbook.Name

--

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

 

[Anders]

Yes - activeworkbook.name did it. For some reason - in help I found and was
trying activeworkbook.fname which wasn'.t

Thanks.