Ask Experts Questions for FREE Help !
Ask
    jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
     
    #1

    Jul 1, 2009, 11:17 AM
    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.
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
     
    #2

    Jul 1, 2009, 08:15 PM

    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.
    jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
     
    #3

    Jul 2, 2009, 06:41 AM
    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.
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
     
    #4

    Jul 2, 2009, 08:58 AM
    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.
    Attached Files
  1. File Type: zip Outlook Export.zip (12.6 KB, 417 views)
  2. jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
     
    #5

    Jul 3, 2009, 03:00 PM
    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 ;)
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
     
    #6

    Jul 3, 2009, 05:44 PM
    Squeak?

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Using Microsoft outlook behind ISA server [ 5 Answers ]

I have access to internet through ISA server. Browsing is fine but I can't check my POP mail through Microsoft outlook. What is the problem ? following error message is shown by outlook The server could not be found (Account :'Hot Pop', POP3 Server: 'pop.hotpop.com', error number: 0x800ccc0d)

Microsoft outlook [ 4 Answers ]

I been trying to download Microsoft outlook to my computer and it won't download and I have windows vista

How to set up Microsoft (2007) Outlook? [ 2 Answers ]

How to set up Microsoft (2007) Outlook?

Microsoft outlook [ 7 Answers ]

When I launch my Microsoft outlook it changes the screen resolution, how do I fix it?

Microsoft Outlook [ 1 Answers ]

Is it possible in the sharred calendars to only view the month with Monday through Friday?


View more questions Search