vba to get email name , subject and attachements on excel list

Status
Not open for further replies.
J

jwalkerack

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Hi there ,

i am not sure if this is possible or if its done via VBA. here is my issue . My work deletes are emails after 3 month period. i have tried backing them up the conventional way , but this did not seem to work. The only way i have been able to do it was to drag all my emails into a folder and have them saved as msg format.

So i now have a folder with lots of msg.

i was wondering if there was a way i could use VBA , to open each file in the folder and take the senders name , the email subject and attachment names date sent and write this into a spreadsheet to make it easier searching

Any help would be great , thanks very much
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
J

jwalkerack

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Hi Diane thanks for getting back to me. i have been trying to set up my Macro Settings in Outlook , but they seem to be diasabled. I am not sure if this is a setting my work have set up automatically. i have tried going to the trust centre but under the macro settings all of the boxed are blanked out. Within the add ins there is a section to load it . But this does not seem to work either
 
Status
Not open for further replies.
< ShowCategoriesDialog for a shared mailbox? | Macro to change folder of rules automatically >
Similar threads
Thread starter Title Forum Replies Date
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
MattC Changing the font of an email with VBA Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
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
B Zoom automatically next email item (VBA) Outlook VBA and Custom Forms 2
A VBA Script - Print Date between first email in Category X and last email in Category Y Outlook VBA and Custom Forms 3
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
K Use VBA to find Sender and Recipient from Microsfot 365 Journaled Email Items Outlook VBA and Custom Forms 3
F VBA code to dock Styles whenever I write or edit an email Outlook VBA and Custom Forms 0
B Adding signature to bottom of VBA reply email Outlook VBA and Custom Forms 1
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
Z VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
R VBA for copying sent email to current folder under a shared mailbox Outlook VBA and Custom Forms 17
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
M VBA to send reminder email if no response Using Outlook 13
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
M Help sending email but removing signature via VBA Outlook VBA and Custom Forms 5
R VBA Code to permanently delete selected email Outlook VBA and Custom Forms 10
B VBA Macro for assigning multiple Categories to an email in my Inbox Outlook VBA and Custom Forms 1
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
skyfox VBA to search email subject field for a certain string Outlook VBA and Custom Forms 3
D VBA to edit body of incoming email and forwarding it Outlook VBA and Custom Forms 11
P Use VBA to alert if new incoming email fits criteria Outlook VBA and Custom Forms 0
U Using VBA to creat hyperlinks in an email Outlook VBA and Custom Forms 3
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
JimG Use VBA to add <style> tag to Email. Outlook VBA and Custom Forms 2
Hudas VBA find and open an email without looping thru each email in the inbox Outlook VBA and Custom Forms 1
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
G VBA Copy draft email to a new email - attachments not copided Using Outlook 7
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
G VBA/Macro to remove page colour when replying or forwarding email Outlook VBA and Custom Forms 2
Dilshad VBA editor opens when sending an email Using Outlook 2
B VBA Code to create appointment from email Outlook VBA and Custom Forms 1
Norbert VBA Flag that would indicate the email was sent from Outlook to Access. Outlook VBA and Custom Forms 2
O VBA Move EMail Outlook VBA and Custom Forms 3
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
D Outlook VBA to open Excel attachment and send recipient's email address to a workbook cell? Using Outlook 4
S Ask user to input email template through VBA Outlook VBA and Custom Forms 1

Similar threads

Top