Solved

Outlook 2010 - macro

Posted on 2013-01-14
13
361 Views
Last Modified: 2013-01-22
My OS is win 7 prof 64 bit and I use Outlook 2010.  
Like everyone I receive lots of emails, and after reading themm, I file the read in spearate folders or sending a reply.
How do I create a macro that
1)  will save the selected email as a Word 2010 document, and I will choose the directory manually.  
2)  file the email in an folder in outlook - I will select the folder when I get the prompt.
Can these two functions be created in one pass.
Thank u.
0
Comment
Question by:jegajothy
  • 7
  • 6
13 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 38777765
Question:
You mention u hv lots of emails ... can you pls enlighten me on why would you want to:
1)  will save the selected email as a Word 2010 document, and I will choose the directory manually.  
?? Will this be on ONLY the selected emails that you need to work on or ???? and why on a Word document ??

Sorry for these questions but need to know the logic behind a behaviour to be able to conceive a macro efficicently.

2)  file the email in an folder in outlook
>>>>
This can be done manually like drag and drop ... why need a macro ?? or also it is only concerning thosee emails that you want to save as word then save them in a folder .. ??

Maybe a short explanation of how you proceed to read ... delete ... file ... transfer your emails would help understanding what you need to acheive.
gowflow
0
 

Author Comment

by:jegajothy
ID: 38779142
In response to gowflow, The reason for saving it as a Word file, is for me to use a bigger font and also to make my own notes and annotations on that document.  And since there will be follow up correspondence on the subject, thus to save them in separate directotires on the hard drive, and also for backup to an external drive.  
On he 2nd point, because of the volume of email in my Inbox, thus after reading them I just move them to a separate folder for filing either under the subject's title or the sender's name.  This folder will also have a copy of my replied messages.
As i am disaster prone in crashing my PCs, this is my 4th pc, thus having backup copies everywhere within my environment is a good strategy.
But I would like to automate the process and save some key strokes in the process.
Thank u.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38781740
ok I have something ready now that is not quite what you want but tell me if ur intrested to look at its an Excel macro that would create a workbook with all the following fields in a selected folder in outlook
Sender Name
Sender Email
Subject
Date Recevied

Basically you open outlook select any folder then activate this macro and it produces a workbook that contain 1 sheet that have all the info (if your folder contains 600 emails you will get a file that has 600 rows with the above info)

If your intrested we can easily add any fieled that you want to that file
Rgds/gowflow
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:jegajothy
ID: 38782378
In response to goflow, OK, I will give it a shot and see how it works out.  Please also include the implementation instructions also.  Thank u.
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 38782660
Very easy open the workbook and follow the instructions pretty straight forward.
Let me know oyur comments.
gowflow
Email-Extraction-Fields.xlsm
0
 

Author Comment

by:jegajothy
ID: 38784268
In response to goflow, good attempt, but the macro did not work.  I opened Outlook and highlighted a folder, and then I opened the file u sent, but it did not do anything, just opened Outlook with a blank sheet. Thank u for trying, good attempt.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38784580
did you enable macroes ??? It is tested and working very fine ! ah ok also you need to do the following:
open vba in the tools menu choose references and then go down in the list and find Microsoft Outlook 12.0 or 14.0 (depending if you hv 2007 or 2010) object library and tick it press ok close that window and save the workbook and try again.

Let me know
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38787303
Hv u been able to tested with the proposed changes ?
gowflow
0
 

Author Comment

by:jegajothy
ID: 38793634
In response to gowflow, I got the following error message :
The code in this project must be updated for use in a 64 bit system.  Please review and update. Declare statements and then make them with Ptrsafe attributes."
I have no clue how to fix the abvoe error. .  Thank u.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38793642
what is your operating system ? mine is Win 7 64 bits and is where I developped it. what is yours ?
gowflow
0
 

Author Comment

by:jegajothy
ID: 38793853
In response to gowflow, yest mine is also win 7 64 bit and I do not understand why I got that error. I have no clue why it happened.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38794209
1) did you run the file I posted and you got the error or you tried to incorporate it in your own workbook and added things ???

2) What version office you use 2007 2010 ?

gowflow
0
 

Author Closing Comment

by:jegajothy
ID: 38808191
thank u it works.  Great
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook Free & Paid Tools
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question