I have linked my MS Access 2016 dbase to my Outlook and the table is working. I now want to extract some information from the content of the emails. An example of the email is below. How can I extract the customer name, number of tickets please? Its been a few years since I programmed and am rusty but I can remember doing this before from within a query. Any help appreciated!
You have received an order from John Doe. The order is as follows:
Order #18893 (June 23, 2017)
No of tickets 3 adults, 2 children
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.