Macro in an excel for outlook.

Status
Not open for further replies.

sri

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Hi All,

Nice to see this wonderful website & blog on outlook. I am ok with excel macro, but a total newbie for outlook macros.
This is my first post. Looking help from the experts to guide me on this.

I am looking for a macro in excel for outlook.
I need this macro to search for 2 specific email Id's & if those email Id's have an word document attached, then it need's to write the following in this excel.
From the mail, the senders email ID, Date & the subject Line.
From the attachment (The macro needs to open the word document) & then write
Project ID (Alphanumerical), Project (Alphanumerical or sometimes only text) &Sub Total (currency numbers, like $1234)

It is for office 2013 version & all the mails are in inbox.
The word document is usually in the RTF extension.

Happy weekend.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Application.Session.GetDefaultFolder(olFolderInbox).Items gives you access to all inbox items. Application in this case points to Outlook, so if you use it in Excel, you need to use another variable for that.

If "email Id" means the email address of the sender, you can use the Find function, which is explained in the VBA help file. If an item is found, loop through it's Attachments collection, and check the extensions of the attached files. If one is rtf, call the Attachment.SaveAsFile method, then open that file in Word and look for the project id etc. by using the functions of the Word object model (Range.Find, which is explained in the Word VBA help file).
 

sri

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
Thanks, Michael, will try it out.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
A Outlook Macro Causing Excel Error Outlook VBA and Custom Forms 0
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
A Macro to Copy Data from Outlook to Excel Spreadsheet Using Outlook 2
P Outlook Macro sends information to Excel Using Outlook 1
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
W How to build a macro that interacts with and uses information from an Excel sh Using Outlook 1
C OL Sub through or by Excel Macro Call Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 3
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
V macro runs slower on startup than after Outlook VBA and Custom Forms 3
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
G VBA Macro Calendar Printing Assistant 4
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
M Outlook macro to automate search and forward process Outlook VBA and Custom Forms 6
R Macro Schedule every day in Outlook Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
4 Macro to set the category of Deleted Item? Outlook VBA and Custom Forms 2
D.Moore Folder view settings by VBA macro Outlook VBA and Custom Forms 57
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
V Outlook Macro to show Flagged messages Outlook VBA and Custom Forms 2
O Run macro automatically at sending an email Using Outlook 11
R Retain Original Message When Forwarding With Macro Outlook VBA and Custom Forms 3
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
R VBA macro - new message Outlook VBA and Custom Forms 3
Similar threads


















































Top