| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
See the code examples on this page
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Anders" <(E-Mail Removed)> wrote in message news:11030F71-6E0C-4D2E-B97E-(E-Mail Removed)... > 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Does ActiveWorkbook.Name give you want you want?
-- Rick (MVP - Excel) "Anders" <(E-Mail Removed)> wrote in message news:11030F71-6E0C-4D2E-B97E-(E-Mail Removed)... > 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
I see now that you want this
Thisworkbook.Name Or ActiveWorkbook.Name -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" <(E-Mail Removed)> wrote in message news:uScvdU$(E-Mail Removed)... > See the code examples on this page > http://www.rondebruin.nl/sendmail.htm > > -- > > Regards Ron de Bruin > http://www.rondebruin.nl/tips.htm > > > > > "Anders" <(E-Mail Removed)> wrote in message news:11030F71-6E0C-4D2E-B97E-(E-Mail Removed)... >> 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Yes - activeworkbook.name did it. For some reason - in help I found and was
trying activeworkbook.fname which wasn'.t Thanks. "Rick Rothstein" wrote: > Does ActiveWorkbook.Name give you want you want? > > -- > Rick (MVP - Excel) > > > "Anders" <(E-Mail Removed)> wrote in message > news:11030F71-6E0C-4D2E-B97E-(E-Mail Removed)... > > 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 > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is there any way to customize the title text of uninstall window? | =?Utf-8?B?UHVjY2E=?= | Microsoft Dot NET | 0 | 24th Aug 2007 09:48 PM |
| How to customize web part title bar? | =?Utf-8?B?Wmhlbnpob25nIFh1?= | Microsoft ASP .NET | 7 | 4th Aug 2007 03:04 PM |
| Customize Title Bar | B. | Microsoft Dot NET Framework Forms | 9 | 23rd Jul 2007 09:07 PM |
| Can I customize Chaging case as adefalut setting for the Title | =?Utf-8?B?U2VyZXRo?= | Microsoft Powerpoint | 2 | 18th Oct 2006 01:05 PM |
| Customize - Close X button in Windows Title Bar | =?Utf-8?B?R2x5bm4=?= | Windows XP Customization | 0 | 18th Oct 2006 11:13 AM |
