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

Tags: , , ,

Modifying data via VBA





 
 
Thread Tools Display Modes
  #1  
Old January 10th 07, 09:26 PM posted to microsoft.public.outlook.program_vba
RLN
external usenet poster
 
Posts: 2
Default Modifying data via VBA

Hello.

I would like to do bulk modifications to the "Category" field of
approx. 900+ contacts.
Does anyone have an example (or know a good site) that would have code
samples to accomplish this on the fly?

Thank you.

Ads
  #2  
Old January 11th 07, 09:28 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,264
Default Modifying data via VBA



Simply loop through the Items collection of the contact folder. Each item
has a Categories property, into which you can write. Then call the item's
Save method.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am 10 Jan 2007 12:26:43 -0800 schrieb RLN:

Hello.

I would like to do bulk modifications to the "Category" field of
approx. 900+ contacts.
Does anyone have an example (or know a good site) that would have code
samples to accomplish this on the fly?

Thank you.

  #3  
Old January 22nd 07, 09:10 PM posted to microsoft.public.outlook.program_vba
RLN
external usenet poster
 
Posts: 2
Default Modifying data via VBA

Michael,
My apologies for the late reply.
Is this something that can be done efficiently in VBScript or are there
other methods you would recommend?


Michael Bauer [MVP - Outlook] wrote:
Simply loop through the Items collection of the contact folder. Each item
has a Categories property, into which you can write. Then call the item's
Save method.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am 10 Jan 2007 12:26:43 -0800 schrieb RLN:

Hello.

I would like to do bulk modifications to the "Category" field of
approx. 900+ contacts.
Does anyone have an example (or know a good site) that would have code
samples to accomplish this on the fly?

Thank you.


  #4  
Old January 23rd 07, 06:53 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,264
Default Modifying data via VBA


If it's needed only once then it doesn't matter. The loop would be faster
though with CDO 1.21 or Redemption (www.dimastr.com).

If you like a comfortable user interface for editing categories then you
might try my Addin, download the English demo via ShareIT (sig below).

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am 22 Jan 2007 12:10:52 -0800 schrieb RLN:

Michael,
My apologies for the late reply.
Is this something that can be done efficiently in VBScript or are there
other methods you would recommend?


Michael Bauer [MVP - Outlook] wrote:
Simply loop through the Items collection of the contact folder. Each item
has a Categories property, into which you can write. Then call the item's
Save method.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am 10 Jan 2007 12:26:43 -0800 schrieb RLN:

Hello.

I would like to do bulk modifications to the "Category" field of
approx. 900+ contacts.
Does anyone have an example (or know a good site) that would have code
samples to accomplish this on the fly?

Thank you.

  #5  
Old February 14th 07, 07:32 PM posted to microsoft.public.outlook.program_vba
rlntemp-gns@yahoo.com
external usenet poster
 
Posts: 1
Default Modifying data via VBA

Michael...thank you for this utility...Again my apologies for the late
reply. I need to better manange my newsgroup monitoring...maybe set
something up somehow where I get receive email when someone posts a
response so my reply doesn't appear rude when tardy.

RLN


 




Thread Tools
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
Modifying recurring events Spenywbl Outlook - Calandaring 0 September 29th 06 06:30 PM
Template Calenders - modifying Hoock the Spook Outlook - Calandaring 0 July 3rd 06 06:07 AM
Modifying Outlook Prieto Chulo Outlook - Using Forms 1 June 20th 06 02:48 AM
Modifying a Form jessica_boxer@yahoo.com Outlook and VBA 1 April 5th 06 01:59 AM


All times are GMT +1. The time now is 04:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Gas Suppliers - Debt Consolidation - Mortgage Calculator - Debt Consolidation - Mortgage Calculator