PC Review


Reply
Thread Tools Rate Thread

customize email title

 
 
Anders
Guest
Posts: n/a
 
      13th Jul 2009
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
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      13th Jul 2009
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

 
Reply With Quote
 
Rick Rothstein
Guest
Posts: n/a
 
      13th Jul 2009
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


 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      13th Jul 2009
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

 
Reply With Quote
 
Anders
Guest
Posts: n/a
 
      13th Jul 2009
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

>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:02 AM.