Ask Experts Questions for FREE Help!
Ask    ||    Answer
 
Advanced  
 

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Programming > Compiled Languages > Visual Basic   »   VBA Code to Save from Microsoft Outlook

 
Thread Tools Search this Thread Display Modes
Question
 
 
#1  
Old Jul 1, 2009, 11:17 AM
jakester's Avatar
jakester
Full Member
jakester is offline
 
Join Date: Jul 2008
Location: Connecticut
Posts: 319
jakester See this member's comment history on his/her Profile page.
VBA Code to Save from Microsoft Outlook

Hello -

I hope my problem is a simple one. What I am attempting to do is create a VBA macro that will allow me to select an e-mail from my Outlook Inbox and save that e-mail (as an Outlook item) to a specified drive—C:\Outlook Items\

I cannot record a macro in Outlook so I am stumped as to how I can do this.

Your help would be greatly appreciated.

Reply With Quote
 
     

Answers
 
 
Old Jul 1, 2009, 08:15 PM   #2  
Ultra Member
Perito is offline
 
Perito's Avatar
 
Join Date: Feb 2009
Location: USA
Posts: 2,881
Perito See this member's comment history on his/her Profile page.Perito See this member's comment history on his/her Profile page.
I wrote a VBA macro for Outlook that does this, and it's somewhere around here. Let me look it up tomorrow and I'll see what I can do. It wasn't trivial to write.
  Reply With Quote
 
     
 
 
Old Jul 2, 2009, 06:41 AM   #3  
Full Member
jakester is offline
 
jakester's Avatar
 
Join Date: Jul 2008
Location: Connecticut
Posts: 319
jakester See this member's comment history on his/her Profile page.
Quote:
Originally Posted by Perito View Post
I wrote a VBA macro for Outlook that does this, and it's somewhere around here. Let me look it up tomorrow and I'll see what I can do. It wasn't trivial to write.
Thanks, Perito. I'll be looking out for it.
  Reply With Quote
 
     
 
 
Old Jul 2, 2009, 08:58 AM   #4  
Ultra Member
Perito is offline
 
Perito's Avatar
 
Join Date: Feb 2009
Location: USA
Posts: 2,881
Perito See this member's comment history on his/her Profile page.Perito See this member's comment history on his/her Profile page.
This program was originally written on Outlook 2003 and the Outlook program was working through a Microsoft Exchange server. I don't think it will have any bearing on the functioning of the macro, but you never know. Parts of the program were created by others. Their code is unchanged and their copyrights are included in the source code. I haven't copyrighted my own code. It's yours to use or modify as you wish.

I had to take the Outlook 2003 .OTM file (Outlook Macro), containing the macro, out of the zip file. Even zipped by itself, that file is too big for the forum. The attached zip file contains two .bas files that can be imported as "modules" and frminfo.frm and frminfo.frx that can be imported as a form. The code is in text format in the two .bas files and in the frminfo.frm file.

By the way, this does a bit more than you're asking. It was originally intended to export all mail messages in all Outlook folders to text files in some directory. Files are named by the message title. Subdirectories are created for folders, and duplicate file names are treated by appending a number in parentheses at the end of the title.

Standard Disclaimer: I'm not responsible for this if it does or doesn't work. Use it at your own risk.

Comments on this post
jakester agrees: much appreciated!
Attached Files
File Type: zip Outlook Export.zip (12.6 KB, 106 views)
  Reply With Quote
 
     
 
 
Old Jul 3, 2009, 03:00 PM   #5  
Full Member
jakester is offline
 
jakester's Avatar
 
Join Date: Jul 2008
Location: Connecticut
Posts: 319
jakester See this member's comment history on his/her Profile page.
Quote:
Originally Posted by Perito View Post
This program was originally written on Outlook 2003 and the Outlook program was working through a Microsoft Exchange server. I don't think it will have any bearing on the functioning of the macro, but you never know. Parts of the program were created by others. Their code is unchanged and their copyrights are included in the source code. I haven't copyrighted my own code. It's yours to use or modify as you wish.

I had to take the Outlook 2003 .OTM file (Outlook Macro), containing the macro, out of the zip file. Even zipped by itself, that file is too big for the forum. The attached zip file contains two .bas files that can be imported as "modules" and frminfo.frm and frminfo.frx that can be imported as a form. The code is in text format in the two .bas files and in the frminfo.frm file.

By the way, this does a bit more than you're asking. It was originally intended to export all mail messages in all Outlook folders to text files in some directory. Files are named by the message title. Subdirectories are created for folders, and duplicate file names are treated by appending a number in parentheses at the end of the title.

Standard Disclaimer: I'm not responsible for this if it does or doesn't work. Use it at your own risk.
Thanks dog
  Reply With Quote
 
     
 
 
Old Jul 3, 2009, 05:44 PM   #6  
Ultra Member
Perito is offline
 
Perito's Avatar
 
Join Date: Feb 2009
Location: USA
Posts: 2,881
Perito See this member's comment history on his/her Profile page.Perito See this member's comment history on his/her Profile page.
Squeak?
  Reply With Quote
 
     

Your Answer
Email me when someone replies to my answer
Join Login





Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

 
Similar Sponsors


Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Similar Threads
microsoft outlook
(5 replies)
How to set up Microsoft (2007) Outlook?
(2 replies)
Microsoft outlook
(7 replies)
Microsoft Outlook
(1 replies)
using Microsoft outlook behind ISA server
(4 replies)

Search this Thread

Advanced Search

Bookmarks

Sponsors



Copyright ©2003 - 2009, Ask Me Help Desk.
All times are GMT -8. The time now is 01:08 AM.