Date/Time Code as tracking # in Subject Line

  • Thread starter Thread starter TOMB
  • Start date Start date
T

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
 
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.
 
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:
 
Back
Top