The functional part that I would like is, while the email is open, to be able to run a VB script that can be executed through Outlook using a macro ( e.g. Alt F8 to execute an outlook Macro ), this macro would execute the VB script. The VB script would execute on the open current message and grab the contents of the message ( From, To, CC, date, time, subject, header, body, footer). Once the message info is captured, go to Filemaker, go to the layout with the log and paste the contents in the email log.
One additional requirement is needed, the incoming message subject line will have a file#, this number needs to be captured so that we find the correct record in Filemaker to enter the data in. Otherwise, the info will be associated with the incorrect record. If there is no recognizable file #, then have an option to input a File# in a dialog window and perform the search and insert.
I need solution as soon as possible with example file.