Default VBA code for extracting data from email (Outlook) to Excel?

Status
Not open for further replies.
Z

zee123

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,

I regularly receive emails which I need to transfer from outlook to a list on Excel. Can I automate this process? The emails are in this form:

IN 31DEC14
FOR:
FROM:
TYPE:
TEL:
ADRS:
CROSS STREET 2:
POLE #:
MSG:

I would like to copy the data after "IN, TYPE, ADRS, MSG" on different columns in Excel. I am a complete beginner and I don't know which resources to use to achieve this. Can someone please guide me, it will be much appreciated. Thank you.
 
Status
Not open for further replies.
< Working with Contact Groups as Addressees | Adding fields to Task in Outlook Home and Business 2010 >
Similar threads
Thread starter Title Forum Replies Date
D Outlook 2021 Using vba code to delete all my spamfolders not only the default one. Outlook VBA and Custom Forms 0
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 4
E Default shape via VBA Outlook VBA and Custom Forms 4
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
V VBA when replying + Default Account Using Outlook 2
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
Diane Poremsky Working with VBA and non-default Outlook Folders Using Outlook 0
C Outlook 2016 - converting Word VBA to default Outlook message Outlook VBA and Custom Forms 0
G Change default font size in sticky notes - Outlook Desktop 2021 Using Outlook 2
T How to set Default FONT for Email composing ? Using Outlook 0
S Default Selection For Multi-Select List Box Outlook VBA and Custom Forms 1
J Set calendar default to 'none' (policy) Exchange Server Administration 3
J Calendar events created on iPhone automatically changing default alert from 'None' to 'Time of Event' Using Outlook.com accounts in Outlook 0
P turn off the default "all day" check box in new calendar items. How? Using Outlook 1
A Outlook 365 New Appointments All saved to a 365 default calendar on Mac Using Outlook 0
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
W Outlook 365 I am getting the "Either there is no default mail client" error when I try to send an email on excel Office 365 Using Outlook 1
P Outlook 2016 Change Paste Special Default Format Using Outlook 8
P default font when sending email from browser Using Outlook 1
nmanikrishnan Auto-reply from default account Using Outlook 1
A force outlook to default to MY calendar Using Outlook 3
e_a_g_l_e_p_i Outlook 2010 How to set default email address for website links Using Outlook 3
V Accepted meetings do not get the default reminder Using Outlook 0
Fozzie Bear Accepted Zoom Invites deleting without going into Default Calendar - Office 2016 Mac Using Outlook 3
W September 2020 - No Default Email Client message after Office Update Using Outlook 1
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
R How to get the Items object of the default mailbox of a specific account in a multiple account Outlook? Outlook VBA and Custom Forms 0
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
F Default font for notes in contacts Using Outlook 1
S Outlook 2010 unable to change default font Using Outlook 7
O How come default profile changed? Using Outlook 2
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
W Message class changes of a custom form changes to the default form Using Outlook 2
T Outlook changes default account Using Outlook 1
P how to remove unwanted PST file default categories assigned to many calendar entries Using Outlook 7
P Reading Pane (Reading Pain?) Default Setting Using Outlook 1
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
P Making iCloud the default calendar for Outlook 2016 Using Outlook 3
M Outlook 2016: Changing default font for Notes and Reading Pane Using Outlook 4
V Change default default save location to Quick Access Using Outlook 1
V Changing default date for task follow-up buttons Using Outlook 2
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
P Outlook.com account overrules default account Using Outlook.com accounts in Outlook 8
P Outlook 2016 Not Default Client Using Outlook 5
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
Mark White VBScript Move sent mail to non-default folder Outlook VBA and Custom Forms 5
Mark White VBScript Move sent mail to non-default folder Outlook VBA and Custom Forms 0
N How to delete default folder "Contacts" (olFolderContacts) in a .pst file Using Outlook 8
D Default Send Account that Works? Using Outlook 0

Similar threads

Back
Top