Outlook 2010 - macro

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.
jegajothyretiredAsked:
Who is Participating?
 
gowflowCommented:
Very easy open the workbook and follow the instructions pretty straight forward.
Let me know oyur comments.
gowflow
Email-Extraction-Fields.xlsm
0
 
gowflowCommented:
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
 
jegajothyretiredAuthor Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
gowflowCommented:
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
 
jegajothyretiredAuthor Commented:
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
 
jegajothyretiredAuthor Commented:
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
 
gowflowCommented:
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
 
gowflowCommented:
Hv u been able to tested with the proposed changes ?
gowflow
0
 
jegajothyretiredAuthor Commented:
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
 
gowflowCommented:
what is your operating system ? mine is Win 7 64 bits and is where I developped it. what is yours ?
gowflow
0
 
jegajothyretiredAuthor Commented:
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
 
gowflowCommented:
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
 
jegajothyretiredAuthor Commented:
thank u it works.  Great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.