Formula for Date

  • Thread starter Thread starter srm
  • Start date Start date
S

srm

I'm new to formulas and just want to display the current date in my
outlook form (e.g., December 18, 2004). What I've done is created a
combination text field where I have the following fields:

[Email Opening Date]

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [Full Name]:

When I send a new message, I then copy the values into my email instead
of copying the data (name, title, address, salutation) one field at a
time. This allows me to personalize the email. The problem is that I
do not know what to do to with formulas to show the current date as I
note above.

Thank you for any help.

srm
 
Sue:

Thank you. I tried Date() and it returns "Tue 12/21/2004 1:07 PM".
Can the format be customized so it returns only "December 21, 2004". I
don't need to inlcude the time and I send many emails internationally
where dates such as 5/6/04 can have different meanings when read.
Thank you for your time.

srm
 
Yes, using either Format() or FormatDate(), depending on the context. But
since your message didn't quote any of the previous conversation, we don't
know what that context is. Please take the time to quote the original
message.
 
Sue:

Thank you. Below is my original request. I hope that is what you are
asking for. I tried Date() and it returns "Tue 12/24/2004 3:57 PM".
What I would like for the value of the [Email Opening Date] field to be
is December 24, 2004 (todays date in long format).

I know I can do this with mail merge with Word which I use alot, but
its alot of steps. I'd like to copy and paste using what I noted below
and I'm close except for the date. What I'd really like is to click on
the New Message button and have that information appear in the body of
the email but that doesn't seem possible.

Thank you.

srm

==========================================

ORIGINAL REQUEST

I'm new to formulas and just want to display the current date in my
outlook form (e.g., December 18, 2004). What I've done is created a
combination text field where I have the following fields:

[Email Opening Date]

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [Full Name]:

When I send a new message, I then copy the values into my email instead
of copying the data (name, title, address, salutation) one field at a
time. This allows me to personalize the email. The problem is that I do
not know what to do to with formulas to show the current date as I note
above.

Thank you for any help.

srm
 
In Outlook form formulas and VB/VBA code, you can use the Format() function
to return the date in the format you want:

Format(Date(), "mmmm dd, yyyy")
 
Sue:

Thank you. If you don't mind, may I ask you a few questions.

Is there help somewhere that shows the use of the Outlook form formulas
and VB/VBA code. I cannot locate help anywhere?

I have about 20 contact folders and each folder I need to create the
same fields for the forms to be used in that folder. Is there a
utility you know of that I can use when creating fields so the same
fields can then be applied to other contact folders? I use fields in
the folder level.

Is there a Microsoft wish list that I can suggest features ? The
ability to click on new message and customize what text can be
automatically added in the body of the email is what I really want.
Thank you. I appreciate all your help.

srm
 
Most of the formula functions are also supported in VB/VBA. Therefore, you
can use the Help facility in VBA. An easy method is to do this is to type
the name of the function in the Immediate window, select it, then press F1.

See http://www.outlookcode.com/d/fields.htm for an article I wrote on fields
that has a link to another article with a code sample that shows how to use
the UserProperties.Add method to add fields to a folder programmatically.

You can send wishes to (e-mail address removed) and (e-mail address removed)
 
Back
Top