A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

VBA code to show today's date + a sequencial number in subject lin



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2  
Old November 11th 09, 05:06 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default VBA code to show today's date + a sequencial number in subject lin



You might use the NewInspector event where you need to identify whether the
new item is your template or not (maybe by the Subject). Then add to the
Subject whatever you want to.

For the number you could store the current value in a text file. Here are
examples for how to read/write a file:

http://www.vboffice.net/sample.html?...4&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 11 Nov 2009 08:00:01 -0800 schrieb NotACoder:

Hello,
I have created a .oft template in Outlook 2003.
I need a VBA code, to display today's date + a sequenyial number, in the
subject line when user uses that template to send me a message. Example:

Case # 1111091 or if it it the 12th email using that template it will be
11110912.

Thank you

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook does not show body. I see From, to, cc, subject, Date, etc Hcruz Outlook - General Queries 6 September 1st 09 02:37 AM
Date/Time Code as tracking # in Subject Line TOMB Outlook and VBA 3 April 29th 08 06:44 AM
calendar keeps returning to today's date scaught Outlook - Calandaring 2 January 17th 08 11:26 PM
All new appointment appear on today's date bglincoln 1 Outlook - Calandaring 0 May 8th 07 05:22 PM
Monthly cal view needs opt default to show today's date at top Doug F WC Outlook - Calandaring 0 June 2nd 06 09:10 PM


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.