Collect Data in subject line to use as variable

  • Thread starter Thread starter Jonathan Schofield
  • Start date Start date
J

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