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:
<http://www.vboffice.net/product.html?pub=6&lang=en>
> 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.
>
>
> "Michael Bauer [MVP - Outlook]" wrote:
>
>>
>>
>> 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.....
>>>
>>> "Michael Bauer [MVP - Outlook]" wrote:
>>>
>>>>
>>>>
>>>> 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]" wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> 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
>>>>>>
>>>>
>>
|
Similar Threads
