Solved

Outlook 2010 - macro

Posted on 2013-01-14
13
364 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 30

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 30

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
Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

 

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 30

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 30

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 30

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 30

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 30

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
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…

710 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