Round_Matt
New Member
Hi Everyone,
I've been trying to extract certain parts of an email body that has been stored in a data item, Issue i am coming across is pulling the following into seperate Data items so they can be used later to input data into a form elsewhere.
From the below text i am trying to extract information such as the Name, Email, Post code, Contact Number.
I have tried a couple of different things like using InStr but its giving me an ouput as a number and not giving me the text.
Can anyone advise anything i could use to get around this?
Thanks
Matt
"From: Company Name Contact Form Submitted <noreply@Business-Name.com>
Date: Fri, 25 Jan 2019 at 08:53
Subject: Company Name Contact Form Submitted: Commercial Property Surveys - www.Company Name.com/contact-us/index.html @ 2019/01/25 08:53:03 (GMT)
To: <enquiry@Company Name.com>
Company Name Contact Form Submitted: Commercial Property Surveys - www.Company Name.com/contact-us/index.html@ 2019/01/25 08:53:03 (GMT)
Reason for Contacting:
Commercial Property Surveys
Name:
matthew round
Company Name:
Business
Email:
matthew.round@Business-Name.com
Telephone:
2035359476
Customer Type:
Post Code:
----- Property Address -----
House No/Property Name:
Building
Address Line 1:
Company Way
Town / City:
Dudley
County:
West Midlands
Post Code:
DY1 1DY
Preferred Date:
Preferred Time:
Your enquiry...:
TESTING FOR AUTO INSERT TO NAV PLEASE FORWARD DIRECTLY TO matthew.round@Business-Name.com
I want to receive marketing communications from Company Name:
unticked, NO do not send offers
PPC:
0
GCLID:
Database ID:
11947
Please consider the environment before printing this e-mail.
Company Name Limited is a trading name of
Company Name UK Ltd registered in England No. 123564
Registered Office: Riverbank, Meadows Business Park, Blackwater, Camberley, Surrey, AA11 1AA.
Information in this message is confidential and is
intended solely for the persons to whom it is addressed.
If you are not the intended recipient please notify the
sender and immediately delete this message from your
computer.
This system may be monitored or recorded to
secure the effective operation of the system
and for other lawful purposes.
"
I've been trying to extract certain parts of an email body that has been stored in a data item, Issue i am coming across is pulling the following into seperate Data items so they can be used later to input data into a form elsewhere.
From the below text i am trying to extract information such as the Name, Email, Post code, Contact Number.
I have tried a couple of different things like using InStr but its giving me an ouput as a number and not giving me the text.
Can anyone advise anything i could use to get around this?
Thanks
Matt
"From: Company Name Contact Form Submitted <noreply@Business-Name.com>
Date: Fri, 25 Jan 2019 at 08:53
Subject: Company Name Contact Form Submitted: Commercial Property Surveys - www.Company Name.com/contact-us/index.html @ 2019/01/25 08:53:03 (GMT)
To: <enquiry@Company Name.com>
Company Name Contact Form Submitted: Commercial Property Surveys - www.Company Name.com/contact-us/index.html@ 2019/01/25 08:53:03 (GMT)
Reason for Contacting:
Commercial Property Surveys
Name:
matthew round
Company Name:
Business
Email:
matthew.round@Business-Name.com
Telephone:
2035359476
Customer Type:
Post Code:
----- Property Address -----
House No/Property Name:
Building
Address Line 1:
Company Way
Town / City:
Dudley
County:
West Midlands
Post Code:
DY1 1DY
Preferred Date:
Preferred Time:
Your enquiry...:
TESTING FOR AUTO INSERT TO NAV PLEASE FORWARD DIRECTLY TO matthew.round@Business-Name.com
I want to receive marketing communications from Company Name:
unticked, NO do not send offers
PPC:
0
GCLID:
Database ID:
11947
Please consider the environment before printing this e-mail.
Company Name Limited is a trading name of
Company Name UK Ltd registered in England No. 123564
Registered Office: Riverbank, Meadows Business Park, Blackwater, Camberley, Surrey, AA11 1AA.
Information in this message is confidential and is
intended solely for the persons to whom it is addressed.
If you are not the intended recipient please notify the
sender and immediately delete this message from your
computer.
This system may be monitored or recorded to
secure the effective operation of the system
and for other lawful purposes.
"