Collect Data in subject line to use as variable

[Jonathan Schofield]

Hi

I have written an application with a form in Outlook that connects to a
SQLServer and writes a New Work request to a database and emails both the
user and myself with details. It appends a unique number and puts this in
the subject line. So far so good. Is it possible for a macro/module in a
toolbar button to read this number and use it in a variable to open the form
with the details recovered from the SQLServer.

Mnay thanks

Jonathan

 

[Sue Mosher [MVP-Outlook]]

As long as there's some regularity, yes, you could certainly use standard
text parsing methods to get information from the MailItem.Subject property
and then use that to build a SQL query.