Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - General Queries (http://www.outlookbanter.com/outlook-general-queries/)
-   -   Auto-text in Form Fields? (http://www.outlookbanter.com/outlook-general-queries/42164-auto-text-form-fields.html)

grep February 28th 07 03:55 PM

Auto-text in Form Fields?
 
I know I've seen the answer to this before, but I can't find it, and I
can't remember what it was...

I want to set up a Form for a weekly email newsletter that I send out.
I'd like the form to have a static Subject line, including the date.
Something like: Your Newsletter is Here - 2/28/2007

I know there's a way to put a field marker or something like that within
the Subject line, that will automatically set the appropriate date, but
I'll be... hmm.... hornswaggled (that's a good word) if I can figure out
what it is!

Any suggestions?


grep

F.H. Muffman February 28th 07 11:58 PM

Auto-text in Form Fields?
 
grep wrote:
I know I've seen the answer to this before, but I can't find it, and I
can't remember what it was...

I want to set up a Form for a weekly email newsletter that I send out.
I'd like the form to have a static Subject line, including the date.
Something like: Your Newsletter is Here - 2/28/2007

I know there's a way to put a field marker or something like that
within the Subject line, that will automatically set the appropriate
date, but I'll be... hmm.... hornswaggled (that's a good word) if I
can figure out what it is!


I'm not sure from what point you need the help, so...

1) Tools - Forms - Design a Form
2) Message, Open
3) Right click the Subject box (not the label) - Properties
4) Value
5) Initial Value, check Set the initial value of this field to:
6) Set it to "Your Newsletter is Here - " & Date()
(note the space after the -... very important for readability)
7) Check Calculate this formula when I compose a new form.
8) Tools - Forms - Publish Form

That *should* work.
--
f.h.




Sue Mosher [MVP-Outlook] March 1st 07 02:24 PM

Auto-text in Form Fields?
 
Bad idea, I'm afraid. Using a custom form to create messages will cause frustration at best for non-Outlook recipients.

A VBA macro might be a better solution.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"F.H. Muffman" wrote in message ...
grep wrote:
I know I've seen the answer to this before, but I can't find it, and I
can't remember what it was...

I want to set up a Form for a weekly email newsletter that I send out.
I'd like the form to have a static Subject line, including the date.
Something like: Your Newsletter is Here - 2/28/2007

I know there's a way to put a field marker or something like that
within the Subject line, that will automatically set the appropriate
date, but I'll be... hmm.... hornswaggled (that's a good word) if I
can figure out what it is!


I'm not sure from what point you need the help, so...

1) Tools - Forms - Design a Form
2) Message, Open
3) Right click the Subject box (not the label) - Properties
4) Value
5) Initial Value, check Set the initial value of this field to:
6) Set it to "Your Newsletter is Here - " & Date()
(note the space after the -... very important for readability)
7) Check Calculate this formula when I compose a new form.
8) Tools - Forms - Publish Form

That *should* work.
--
f.h.





All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com