Date/Time Code as tracking # in Subject Line
 

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

Date/Time Code as tracking # in Subject Line
 

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

Date/Time Code as tracking # in Subject Line
 

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

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