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.
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.
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.
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.
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.
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.