Auto Date a Standard Form

[PSULionRP]

I have a form I have set-up that I send out everyday. Is there any way that I
can Auto Date the form??? Like in my Subject Line I refer to the Day and
Date, ex. Tuesday, April 1st, and I slao reference the day and date within
the body of the e-mail form.

Any help would be greatly appreciated and Thnaks in advance for your help.

PSULionRP

 

[Michael Bauer [MVP - Outlook]]

Where do you want the auto date?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 31 Mar 2008 10:34:39 -0700 schrieb PSULionRP:

 

[PSULionRP]

I reference the day and date in the Subject line of my standard form and in
the body of the e-mail itself. I just wasn't sure if there was a way to auto
date within a form. Like using the Excel equivalent of "=TODAY()". Just as a
means of making my standard form more intelligent and saving keystrokes and
time is all.

 

[Michael Bauer [MVP - Outlook]]

You can prepare the subject and body by inserting a placeholder, e.g.
"[@date]" (without quotations).

Then customize the form, open the VBScript editor and insert this sample
code:

Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Apr 2008 05:33:00 -0700 schrieb PSULionRP:

 

[PSULionRP]

That didn't work. I put [@date] in my subject line and within the body. When
I opened the template it displayed "[@date]"...

Any help would be appreciated.....

You can prepare the subject and body by inserting a placeholder, e.g.
"[@date]" (without quotations).

Then customize the form, open the VBScript editor and insert this sample
code:

Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Apr 2008 05:33:00 -0700 schrieb PSULionRP:

I reference the day and date in the Subject line of my standard form and in
the body of the e-mail itself. I just wasn't sure if there was a way to auto
date within a form. Like using the Excel equivalent of "=TODAY()". Just as a
means of making my standard form more intelligent and saving keystrokes and
time is all.

 

[Michael Bauer [MVP - Outlook]]

What did you do with the code?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 10 Apr 2008 14:36:00 -0700 schrieb PSULionRP:

That didn't work. I put [@date] in my subject line and within the body. When
I opened the template it displayed "[@date]"...

Any help would be appreciated.....

You can prepare the subject and body by inserting a placeholder, e.g.
"[@date]" (without quotations).

Then customize the form, open the VBScript editor and insert this sample
code:

Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Apr 2008 05:33:00 -0700 schrieb PSULionRP:

I reference the day and date in the Subject line of my standard form and in
the body of the e-mail itself. I just wasn't sure if there was a way to auto
date within a form. Like using the Excel equivalent of "=TODAY()". Just

as
a

means of making my standard form more intelligent and saving keystrokes and
time is all.

:



Where do you want the auto date?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 31 Mar 2008 10:34:39 -0700 schrieb PSULionRP:

I have a form I have set-up that I send out everyday. Is there any way
that I
can Auto Date the form??? Like in my Subject Line I refer to the Day and
Date, ex. Tuesday, April 1st, and I slao reference the day and date within
the body of the e-mail form.

Any help would be greatly appreciated and Thnaks in advance for your help.

PSULionRP

 

[PSULionRP]

Ok...Here's what I did.

I opened my Form...Tools ==> Forms ==> Chhose Form

Once my form was opened, I added [@date] to the Subject Line and it now
reads...

TESTING 1-2-3-4---[@date]

I also added it to the body of the e-mail, testing it a couple of ways and
that reads...

Test using todays's date @date
or [@date]


I then went to VB... Tools ==> Macro ==> Visual Basic Editor

I added the code you had previously suggested to Modules in Module 1...


Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

A Visual Basic even novice I am not. So I'm sure it's something I have done
within VB.

I appreciate your feedback and help Michael.

Thanks.

What did you do with the code?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 10 Apr 2008 14:36:00 -0700 schrieb PSULionRP:

That didn't work. I put [@date] in my subject line and within the body. When
I opened the template it displayed "[@date]"...

Any help would be appreciated.....

You can prepare the subject and body by inserting a placeholder, e.g.
"[@date]" (without quotations).

Then customize the form, open the VBScript editor and insert this sample
code:

Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Apr 2008 05:33:00 -0700 schrieb PSULionRP:

I reference the day and date in the Subject line of my standard form and
in
the body of the e-mail itself. I just wasn't sure if there was a way to
auto
date within a form. Like using the Excel equivalent of "=TODAY()". Just as
a
means of making my standard form more intelligent and saving keystrokes
and
time is all.

:



Where do you want the auto date?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 31 Mar 2008 10:34:39 -0700 schrieb PSULionRP:

I have a form I have set-up that I send out everyday. Is there any way
that I
can Auto Date the form??? Like in my Subject Line I refer to the Day and
Date, ex. Tuesday, April 1st, and I slao reference the day and date
within
the body of the e-mail form.

Any help would be greatly appreciated and Thnaks in advance for your
help.

PSULionRP

 

[Michael Bauer [MVP - Outlook]]

Am Fri, 11 Apr 2008 05:44:01 -0700 schrieb PSULionRP:

Sorry for the delay, I miss some threads these days.

The code isn't for the VBA editor but VBScript. When you have opened the
form, click Tools/Forms/Customize to customize it. Then open the
VBScript editor and paste the code there.

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:

Ok...Here's what I did.

I opened my Form...Tools ==> Forms ==> Chhose Form

Once my form was opened, I added [@date] to the Subject Line and it now
reads...

TESTING 1-2-3-4---[@date]

I also added it to the body of the e-mail, testing it a couple of ways and
that reads...

Test using todays's date @date
or [@date]


I then went to VB... Tools ==> Macro ==> Visual Basic Editor

I added the code you had previously suggested to Modules in Module 1...


Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

A Visual Basic even novice I am not. So I'm sure it's something I have done
within VB.

I appreciate your feedback and help Michael.

Thanks.

What did you do with the code?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 10 Apr 2008 14:36:00 -0700 schrieb PSULionRP:

That didn't work. I put [@date] in my subject line and within the

body.
When

I opened the template it displayed "[@date]"...

Any help would be appreciated.....

:



You can prepare the subject and body by inserting a placeholder, e.g.
"[@date]" (without quotations).

Then customize the form, open the VBScript editor and insert this sample
code:

Function Item_Open()
Item.Subject = Replace(Item.Subject, "[@date]", Date)
Item.HTMLBody = Replace(Item.HTMLBody, "[@date]", Date)
End Function

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Apr 2008 05:33:00 -0700 schrieb PSULionRP:

I reference the day and date in the Subject line of my standard form and
in
the body of the e-mail itself. I just wasn't sure if there was a way to
auto
date within a form. Like using the Excel equivalent of "=TODAY()".

Just
as

a
means of making my standard form more intelligent and saving keystrokes
and
time is all.

:



Where do you want the auto date?

--
Best regards
Michael Bauer - MVP Outlook
Outlook Categories? Category Manager Is Your Tool:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 31 Mar 2008 10:34:39 -0700 schrieb PSULionRP:

I have a form I have set-up that I send out everyday. Is there any way
that I
can Auto Date the form??? Like in my Subject Line I refer to the

Day
and

Date, ex. Tuesday, April 1st, and I slao reference the day and date
within
the body of the e-mail form.

Any help would be greatly appreciated and Thnaks in advance for your
help.

PSULionRP