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

Date/Time Code as tracking # in Subject Line



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4  
Old April 29th 08, 06:44 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Date/Time Code as tracking # in Subject Line



VBScript behind a form should be possible, but I'd do it with VBA, or as an
Addin if you want to deploy it to many clients.

In VBA, the numeric value for the time is: cdbl(now).

--
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, 28 Apr 2008 15:04:01 -0700 schrieb TOMB:

How would you suggest this be done?

I have looked at using forms, but have not been succesful in getting both
the text and numeric value of the date. Therefore was looking to see if
solution was using VBA to create subject line.

If using a form to accomplish works, all the better.

"Michael Bauer [MVP - Outlook]" wrote:



What is your question?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 25 Apr 2008 13:12:00 -0700 schrieb TOMB:

I would like to grenerate a tracking number which is automatically

inserted
in the subject line of a message. I hope to use some fixed text along

with
a
number. Example: CNA-AccountName-39563.63

In this case, 39563.63 is the numeric value for 4/25/2008 15:09

Thanks in advance


 




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
Meeting start date/time changes to current date/time Dave H Outlook - Calandaring 0 February 14th 08 02:18 PM
need help with vba code to input data on certain date and move to next cell for the following date. [email protected] Outlook and VBA 1 May 30th 07 04:45 PM
Adding a date to the Subject line in a rule cableguy47905 via OfficeKB.com Outlook and VBA 12 April 24th 07 07:38 PM
predefined subject line with date dries Outlook and VBA 3 February 5th 07 09:54 PM
Code to extract subject line [email protected] Outlook and VBA 3 August 25th 06 06:54 PM


All times are GMT +1. The time now is 11:37 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.