Solved

Outlook 2010 - macro

Posted on 2013-01-14
13
365 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 31

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 31

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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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 31

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 31

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 31

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 31

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 31

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

617 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