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

Status
Not open for further replies.

mizsporty

Member
Outlook version
Outlook 2007
Email Account
POP3
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


Email


Phone Number


Male


Female


Age


Comments
 

Forum Admin

Senior Member
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

Comment

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

and
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))
Next

and
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. )
 

mizsporty

Member
Outlook version
Outlook 2007
Email Account
POP3
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:
 

Gemmma Needham

New Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3
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
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B PLEASE READ: Important information about the availability of Business Contact Manager 2010 Using Outlook 1
S cross post please read: Exchange Account password prompt in Outlook 2010 Using Outlook 2
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 New Slipstick.com Articles 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
O Add please, Outlook Autocomplete working per account in multi profile ! Outlook Wishlist 5
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
L PLEASE HELP: reconnect existing PST file to imap account Using Outlook 5
L PLEASE HELP: reconnect existing PST file to imap account Using Outlook 1
B Please help! Outlook, Exchange Server, and Customization BCM (Business Contact Manager) 2
Similar threads


















































Top