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

Status
Not open for further replies.

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

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

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.
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 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
G Adding an attachment to email I just created (VBA) Outlook VBA and Custom Forms 1
S VBA to identify a specific email and copy the attachment from it to the network Outlook VBA and Custom Forms 4
M VBA code to save email attachments (PDF) as email subject line Outlook VBA and Custom Forms 1
J Email Parsing VBA Script for Outlook - NEEDED Outlook VBA and Custom Forms 7
J Outlook VBA for Email Filter Outlook VBA and Custom Forms 2

Similar threads

Top