Oh please read---> Extracting email web leads on to excel spread sheet

Not open for further replies.


Outlook version
Email Account
Thank you very much for reading this & assisting.

I currently receive all my web leads from my website into Outlook 2007. The screen shot of the email is below. Please bare with me... I am severely computer challenged. I have been up all night and am still lost. I really appreciate all help.

I wanted to find out how to extract the data from those emails and convert them into a excel spreadsheet. How do I get exact fields?

First Name

Last Name


Phone Number




Start with Copy messages to an excel worksheet or extract data from email - both use the same method but include different examples.

Your pattern:

First name -- Bill

Last name -- Smith

email -- alias@domain.com

phone -- 2025551212

Age -- 33

Sex -- Male


Because the pattern is the same, with -- separating the values, i'd use the first example and 1 pattern and set global to true so it will pick up every -- line.
Dim vText, vText2, vText3, vText4, vText5, vText6, vText7 As Variant

With Reg1
.Pattern = "(--\s(.*)\s*)\n"
.Global = True

End With

For Each M In M1
vText = Trim(M.SubMatches(1))
vText2 = Trim(M.SubMatches(2))
vText3 = Trim(M.SubMatches(3))
vText4 = Trim(M.SubMatches(4))
vText5 = Trim(M.SubMatches(5))
vText6 = Trim(M.SubMatches(6))
vText7 = Trim(M.SubMatches(7))

xlSheet.Range("B" & rCount) = vText
xlSheet.Range("c" & rCount) = vText2
xlSheet.Range("d" & rCount) = vText3
xlSheet.Range("e" & rCount) = vText4
xlSheet.Range("f" & rCount) = vText5
xlSheet.Range("f" & rCount) = vText6
xlSheet.Range("f" & rCount) = vText7

(I'm going to delete your screenshot because of the personal information in it. )
Thank you for replying, I apologize but when I stated earlier I was computer challenged... I was serious.

Would you mind simplifying what you said... or a set of directions. I don't even know where, what, or how to do this

Thank you:rolleyes:
Hi, I'm trying to use this method to extract similar data from an email. I've got as far as writing the code, but I need to use a : as the identifier. There's 4 lines of data I need to extract, but this only seems to be pulling the last line.

Can you advise?

Thanks, Gemma
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Please remind me how I added this message button Outlook VBA and Custom Forms 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 4
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
C Outlook 365 Microsoft Support - Please Advise Using Outlook 3
S.Champ Please help? I've imported a random workcalendar I dont even know who's. Can I undo it? and then I need to re-sync the google one again. Its a mess:( Using Outlook 2
N Please advise code received new mail Using Outlook 0
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
L Attachment saving and tracking - PLEASE help! Outlook VBA and Custom Forms 5
T Missing text in e-mail message after "(Please keep confidential)" Using Outlook 3
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
D Command Button code will not execute. Any suggestions Please. Outlook VBA and Custom Forms 2
L Outlook 2002: HTML Emails Will Not Print: Please Help Using Outlook 0
Diane Poremsky Testing please ignore Using Outlook 1
G Outlook 2010 VBA Coding Assistance please! Outlook VBA and Custom Forms 5
joflo copy contents from outlook to excell - please help. Using Outlook 4
A Help with VBA please! Outlook VBA and Custom Forms 15
Denis Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>> Using Outlook 1
V Please help if you can. Problems with Bcc BCM (Business Contact Manager) 3
C Please Help outlook 2013 Using Outlook 1
J Please help to clarify an IMAP issue Using Outlook 7
M Address book doesn't update contacts? Please any help would be great! Exchange Server Administration 4
N Please help....winmail.dat issue...slowly going insane..... Using Outlook 1
E Need a bit of education on how Outlook works please Using Outlook 3
B Can someone please explain account set up from script Using Outlook 1
A help please -Boolean - can I use .AND NOT etc in a rule Exchange Server Administration 0
A Advanced find query facilty Help please Using Outlook 2
F Which upgrade should I go for and how do I do it please? Using Outlook 2
C Can't import distribution list - help, please Using Outlook 1
F Help with Outlook 2007 Macro Please! Using Outlook 4
V [duplicates duplicates duplicates] please help Using Outlook 26
I can't view email body please help! Using Outlook 6
R VBA Macro to VBScript in a form- Help Please! Using Outlook 10
M please customize this code Using Outlook 1
M please customize this code Using Outlook 1
S Need solution to Outlook mail handling/syncing/mobile situation, please Using Outlook 2
S Please help! -- Linked Account field at Business Contacts tab is always empty BCM (Business Contact Manager) 1
e_a_g_l_e_p_i Can someone please answer a question about tasks for me Using Outlook 2
A outlook error Receiving reported error (0x80040900) please help Using Outlook 4
D Help please my Outlook is frozen Using Outlook 3
H Outlook 2010: Cannot start!, please help me! Using Outlook 3
D Outlook 2007 not working>> Please help tried everything Using Outlook 3
U Need a help please Outlook 2007 crashing Using Outlook 2
M Updates to exchange server broke code - please help Using Outlook 2
K shared inbox help please Using Outlook 0
P Please Help me Create a Macro ! Using Outlook 2
J Help please Using Outlook 30
D A little bit of help with headers please? Exchange Server Administration 1

Similar threads