Solved

Outlook 2010 - macro

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

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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 …

706 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now