A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

VBA for Move Items dialog?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 18th 12, 04:42 PM
Doug B Doug B is offline
Junior Member
 
First recorded activity at Outlookbanter: Mar 2012
Posts: 1
Unhappy VBA for Move Items dialog?

Prior to my computer crash, I had two 'profiles' in Outlook 2007, which seemed logical, but was actually somewhat of a pain. Using one profile for friend/general emails, and another for soccer/swim emails for the kids' teams.

After the crash, I decided it's easier to combine them, and I was right, so much easier having it send/receive 6 email addresses in one profile instead of splitting it up. So now, here's my dilemna.

Manually, I will move an email to the proper subfolder (such as soccer/daughter, or swimming/volunteer) and then click Reply. This is nice so that it keeps the reply in the same folder with the original message. If I reply first, the message goes to the 'sent' folder, then I need to move messages from the sent folder as well as the source folder.

Using the traditional method, I either right click and choose move, or hit Ctrl-V. It opens up the Move Items dialog, which lets me choose a folder.

I wrote some VBA code that will 1) mark the item as read, b) move the item to folder XXX, and c) reply to that item. This accomplishes my goal about 50%.

I added an inputbox asking "push d for daughter, v for volunteer" and then it lets me plug in the folder name. This got me about 75% toward my goal. But those are hard coded.

What I really want is to be able to show that Move Items dialog so I can pick a folder dynamically, in case I want to choose a less-used folder for my storage.

Any tips on opening that dialog box, or anything else that might make my code easier, would be well appreciated.

Thanks,

Doug B.
Ads
  #2  
Old March 19th 12, 06:37 AM
marshal_hubs marshal_hubs is offline
Junior Member
 
First recorded activity at Outlookbanter: Jan 2012
Posts: 18
Default

Quote:
Originally Posted by Doug B View Post
Prior to my computer crash, I had two 'profiles' in Outlook 2007, which seemed logical, but was actually somewhat of a pain. Using one profile for friend/general emails, and another for soccer/swim emails for the kids' teams.

After the crash, I decided it's easier to combine them, and I was right, so much easier having it send/receive 6 email addresses in one profile instead of splitting it up. So now, here's my dilemna.

Manually, I will move an email to the proper subfolder (such as soccer/daughter, or swimming/volunteer) and then click Reply. This is nice so that it keeps the reply in the same folder with the original message. If I reply first, the message goes to the 'sent' folder, then I need to move messages from the sent folder as well as the source folder.

Using the traditional method, I either right click and choose move, or hit Ctrl-V. It opens up the Move Items dialog, which lets me choose a folder.

I wrote some VBA code that will 1) mark the item as read, b) move the item to folder XXX, and c) reply to that item. This accomplishes my goal about 50%.

I added an inputbox asking "push d for daughter, v for volunteer" and then it lets me plug in the folder name. This got me about 75% toward my goal. But those are hard coded.

What I really want is to be able to show that Move Items dialog so I can pick a folder dynamically, in case I want to choose a less-used folder for my storage.

Any tips on opening that dialog box, or anything else that might make my code easier, would be well appreciated.

Thanks,

Doug B.
Hi Doug,

Using Outlook VBA, you can try: Pickfolder method to get the folder/open the dialog box. In order to move ahead, i attached a small VBA code snippet:

Try this out and let me know, how it goes...
Attached Images
File Type: jpg Step.jpg (29.4 KB, 2 views)
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Open File Selector dialog in VBA Peter Hibbs Outlook and VBA 4 August 20th 09 07:34 PM
delete button doesn't move items to deleted items folder Anne Outlook - Installation 4 April 16th 09 03:46 PM
how/what dialog boxes can I display from VBA code masani paresh[_3_] Outlook and VBA 1 March 20th 09 04:27 PM
Outlook 2007: Show attendees dialog with vba Marc M. Outlook and VBA 1 September 10th 08 03:41 PM
Can't delete items or move items in Outlook 2002 Garret Swayne Outlook - General Queries 2 April 14th 06 09:15 AM


All times are GMT +1. The time now is 04:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.