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

Status
Not open for further replies.

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.
Similar threads
Thread starter Title Forum Replies Date
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 New Slipstick.com Articles 0
C Outlook 2016 - converting Word VBA to default Outlook message Outlook VBA and Custom Forms 0
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
T Changing default Mail Account in Outlook 2016 - POP3 Using Outlook 1
J Setting default address book Using Outlook 0
V importing appointments to non-default calendar? Using Outlook 1
C Change default colors for conditional formatting Using Outlook 2
S Default Font in body of Task Using Outlook 0
Diane Poremsky Set Another Data File as Default When Using an Exchange Account New Slipstick.com Articles 0
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
Diane Poremsky Shared Mailboxes and the Default 'Send From' Account New Slipstick.com Articles 0
Diane Poremsky To Change the Default E-mail Program in Windows New Slipstick.com Articles 0
C Delete Subject-Add Organizer to all Reservations in Default Calendar. Using Outlook 0
Diane Poremsky Setting the default Country for Outlook Contacts New Slipstick.com Articles 0
B Outlook 2016: Can't delete default calendar but I don't use it Using Outlook 7
B Calendar shows too much info by default Using Outlook 0
M Default Calendar Using Outlook 0
L Change default from english to danish ...... Using Outlook 5
R Making Outlook default client in share charm Using Outlook 4
B changing Win7 default backup schedule for Previous Versions Using Outlook 0
Diane Poremsky Changing the default *.pst and *.ost sizes New Slipstick.com Articles 0
E Outlook 2016 Default Blue Color Using Outlook 3
J Installed Outlook but Default Calendar is Blank Using Outlook 3

Similar threads

Top