![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Using Outlook 2003. There is a requirement at work where we move all
contacts from a particular folder to another folder on a regular basis. Is it possible to induce "Select All" and then "Move to Folder" for Contacts in Outlook via VBA for a folder? If not, which would be the quickest way to do it instead of iterating through every contact item and then moving it. I know the source folder and the target folder and only want to move the contacts in the most efficient way. Looking forward to your suggestions. Thanks in advance ! |
#3
|
|||
|
|||
![]()
Hi Ken,
Thank you for the quick reply. Yes, that is what I am presently doing but find that the manual approach of selecting all the contacts using Edit - Select All in the folder and then moving it to the target folder seems to be fractionally quicker (especially when the number of contacts are large). Hence the question if its possible to get a VBA equivalent of this using the command bars or something else. Jonathan "Ken Slovak - [MVP - Outlook]" wrote: You can copy/move an entire folder to another location, including contents. But for what you want you'd have to iterate the Items collection of the folder and move each item in turn, using a down counting loop. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Jonathan B" Jonathan wrote in message ... Using Outlook 2003. There is a requirement at work where we move all contacts from a particular folder to another folder on a regular basis. Is it possible to induce "Select All" and then "Move to Folder" for Contacts in Outlook via VBA for a folder? If not, which would be the quickest way to do it instead of iterating through every contact item and then moving it. I know the source folder and the target folder and only want to move the contacts in the most efficient way. Looking forward to your suggestions. Thanks in advance ! |
#4
|
|||
|
|||
![]()
It's faster because you're using the Outlook object model, which calls
Extended MAPI and Outlook is directly using Extended MAPI. If you were to code the copy operation using Extended MAPI it would be as fast as Outlook is. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Jonathan B" wrote in message ... Hi Ken, Thank you for the quick reply. Yes, that is what I am presently doing but find that the manual approach of selecting all the contacts using Edit - Select All in the folder and then moving it to the target folder seems to be fractionally quicker (especially when the number of contacts are large). Hence the question if its possible to get a VBA equivalent of this using the command bars or something else. Jonathan |
#5
|
|||
|
|||
![]()
Ken,
Thanks for information. So can Extended MAPI be implemented using VBA or VB? I did a search since this is a relatively new arena for me but from initial impressions it appears can't be done with VBA or VB. Am I correct? Another issue I have noticed is that the move seems to fire the Birthday/Anniversary date event (if present) causing duplicates in the Calendar. Any suggestions on how I can avoid this? Currently I am capturing the Add event and deleting it. If there is another better approach, I'm all ears. Thanks once again ! Jonathan "Ken Slovak - [MVP - Outlook]" wrote: It's faster because you're using the Outlook object model, which calls Extended MAPI and Outlook is directly using Extended MAPI. If you were to code the copy operation using Extended MAPI it would be as fast as Outlook is. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Jonathan B" wrote in message ... Hi Ken, Thank you for the quick reply. Yes, that is what I am presently doing but find that the manual approach of selecting all the contacts using Edit - Select All in the folder and then moving it to the target folder seems to be fractionally quicker (especially when the number of contacts are large). Hence the question if its possible to get a VBA equivalent of this using the command bars or something else. Jonathan |
#6
|
|||
|
|||
![]()
Extended MAPI can mostly only be programmed using C++ or Delphi. There are a
few properties you can read using MAPI from VBA but it's a hack and you can't do complex things like moving items using VBA/VB. You would have to do what you're doing for any reminders you don't want replicated or clear the reminder flag on the item when you have it instantiated and before you move it. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Jonathan B" wrote in message ... Ken, Thanks for information. So can Extended MAPI be implemented using VBA or VB? I did a search since this is a relatively new arena for me but from initial impressions it appears can't be done with VBA or VB. Am I correct? Another issue I have noticed is that the move seems to fire the Birthday/Anniversary date event (if present) causing duplicates in the Calendar. Any suggestions on how I can avoid this? Currently I am capturing the Add event and deleting it. If there is another better approach, I'm all ears. Thanks once again ! Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving CONTACTS to Shared Public contact folder | RHill | Outlook - Using Contacts | 1 | August 23rd 06 05:14 PM |
Moving my contacts folder to a new machine | Dave | Outlook - Using Contacts | 2 | August 5th 06 05:57 PM |
Moving Folder | Denis R Charron | Outlook - General Queries | 0 | June 27th 06 06:33 PM |
Moving Sent Items to a different folder | Dipu Jose | Outlook - General Queries | 1 | June 1st 06 12:39 PM |
Moving the contents of my Contacts folder | Setnan | Outlook - Using Contacts | 1 | May 19th 06 11:58 AM |