Labrat407
02-10-2014, 02:06 PM
Hello,
I am looking for a Macro to assist in archiving our folders from a group mailbox. I have found this ( http :// vbaexpress.com/kb/getarticle.php?kb_id=875#instr ) (I can not yet post links) macro, it is a start, but I get an error when it tries to create the folder, due in part to the depth of the folder string. Also I am looking to save the email in a slightly different format.
Intended macro functionality:
As per the earlier link, allow the user to select the folder to archive
As per the earlier link, allow the user to select the folder to archive to
The folder location should default to one specific location and allow the selection under that folder to save to
Only the Outlook Folder name is to beused, not the Outlook Folder path and current folder
This is the tricky one, the emails should be saves as embeded objects in a word document with the same name as the folder.
Outlook Version 14 and Office 2010
If the folder exists, allow the ability to append the current word document (nice to have)
My current error is Run-time error '76': Path not found when it gets to this line FSO.CreateFolder (StrFolderPath)
The string is similar to this (stripped out identy keywords) "G:\folder1\Folder2\Team\My_folder\email_test\Inbox\4000 outlook1\4100 Outlook Agents\4120 Minemy\1-FUP\"
I would like to have "G:\folder1\Folder2\Team\My_folder\email_test\FolderPathHere\"
I am passingly comfortable with code with Googles kind help, but getting folder structures and Objects in other applications is not yet a strength. I am working on this on my own but would appreciate any help.
:help
Thanks
I am looking for a Macro to assist in archiving our folders from a group mailbox. I have found this ( http :// vbaexpress.com/kb/getarticle.php?kb_id=875#instr ) (I can not yet post links) macro, it is a start, but I get an error when it tries to create the folder, due in part to the depth of the folder string. Also I am looking to save the email in a slightly different format.
Intended macro functionality:
As per the earlier link, allow the user to select the folder to archive
As per the earlier link, allow the user to select the folder to archive to
The folder location should default to one specific location and allow the selection under that folder to save to
Only the Outlook Folder name is to beused, not the Outlook Folder path and current folder
This is the tricky one, the emails should be saves as embeded objects in a word document with the same name as the folder.
Outlook Version 14 and Office 2010
If the folder exists, allow the ability to append the current word document (nice to have)
My current error is Run-time error '76': Path not found when it gets to this line FSO.CreateFolder (StrFolderPath)
The string is similar to this (stripped out identy keywords) "G:\folder1\Folder2\Team\My_folder\email_test\Inbox\4000 outlook1\4100 Outlook Agents\4120 Minemy\1-FUP\"
I would like to have "G:\folder1\Folder2\Team\My_folder\email_test\FolderPathHere\"
I am passingly comfortable with code with Googles kind help, but getting folder structures and Objects in other applications is not yet a strength. I am working on this on my own but would appreciate any help.
:help
Thanks