PC Review


Reply
Thread Tools Rate Thread

Can you change records in bulk?

 
 
=?Utf-8?B?U3RldmUgTWF1c3Q=?=
Guest
Posts: n/a
 
      11th Oct 2007
I want to change the classification of 1000 leads by adding a check mark to
the lead dialog box in the contact modify pane. Is there a provision in BCM
or Outlook to change fields in records in bulk throug a query?
 
Reply With Quote
 
 
 
 
Lon Orenstein
Guest
Posts: n/a
 
      11th Oct 2007
Steve:

Here's what Judy wrote earlier in this newsgroup:

group by whatever field you need to modify, for example State. To change a
lot of Contacts' State at once, drag them from one state group to another.

In case you don't know how to group: To group, turn on the Advanced
Toolbar. Turn on the Group By Box. Drag the field header you want to group
by, into the Group By Box.

This works for changes of Company name as well. Group by Company field.
Change one manually, then drag the rest into that group.

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(E-Mail Removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com



"Steve Maust" <Steve (E-Mail Removed)> wrote in message
news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
>I want to change the classification of 1000 leads by adding a check mark to
> the lead dialog box in the contact modify pane. Is there a provision in
> BCM
> or Outlook to change fields in records in bulk throug a query?


 
Reply With Quote
 
=?Utf-8?B?U3RldmUgTWF1c3Q=?=
Guest
Posts: n/a
 
      12th Oct 2007
Thanks that partially answeres my question, I am looking to change the
classification of 1000 contacts so that the "lead" check box is checked so
the contacts will show in my "address card (leads)" view and they will be
seperated from my other business contacts. I cant find anyway to create a
group by contacts that have the lead box checked. Your further help would be
appreciated
Steve

"Lon Orenstein" wrote:

> Steve:
>
> Here's what Judy wrote earlier in this newsgroup:
>
> group by whatever field you need to modify, for example State. To change a
> lot of Contacts' State at once, drag them from one state group to another.
>
> In case you don't know how to group: To group, turn on the Advanced
> Toolbar. Turn on the Group By Box. Drag the field header you want to group
> by, into the Group By Box.
>
> This works for changes of Company name as well. Group by Company field.
> Change one manually, then drag the rest into that group.
>
> HTH,
> Lon
>
> ___________________________________________________________
> Lon Orenstein
> pinpointtools, llc
> (E-Mail Removed)
> Author of Outlook 2007 Business Contact Manager For Dummies
> Author of the eBook: Moving from ACT! to Business Contact Manager
> www.pinpointtools.com
>
>
>
> "Steve Maust" <Steve (E-Mail Removed)> wrote in message
> news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
> >I want to change the classification of 1000 leads by adding a check mark to
> > the lead dialog box in the contact modify pane. Is there a provision in
> > BCM
> > or Outlook to change fields in records in bulk throug a query?

>

 
Reply With Quote
 
Lon Orenstein
Guest
Posts: n/a
 
      12th Oct 2007
Sorry Steve... you have to change one record first, then when you group by
the Lead field, you'll have two groups -- one with one contact in it that
you just changed, and all your other contacts that were not changed.
Highlight all the unchanged contacts and left click/drag them all to the
Lead grouping. You'll see a little tooltip popup that says something like
"Change value to Lead". Drop them on that grouping and the data will be
updated.

I'm 99% sure that there are longer instructions in this newsgroup also...
it's been explained before.

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(E-Mail Removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com



"Steve Maust" <(E-Mail Removed)> wrote in message
news:C2EA6EC8-503E-4D57-AEEB-(E-Mail Removed)...
> Thanks that partially answeres my question, I am looking to change the
> classification of 1000 contacts so that the "lead" check box is checked so
> the contacts will show in my "address card (leads)" view and they will be
> seperated from my other business contacts. I cant find anyway to create a
> group by contacts that have the lead box checked. Your further help would
> be
> appreciated
> Steve
>
> "Lon Orenstein" wrote:
>
>> Steve:
>>
>> Here's what Judy wrote earlier in this newsgroup:
>>
>> group by whatever field you need to modify, for example State. To change
>> a
>> lot of Contacts' State at once, drag them from one state group to
>> another.
>>
>> In case you don't know how to group: To group, turn on the Advanced
>> Toolbar. Turn on the Group By Box. Drag the field header you want to
>> group
>> by, into the Group By Box.
>>
>> This works for changes of Company name as well. Group by Company field.
>> Change one manually, then drag the rest into that group.
>>
>> HTH,
>> Lon
>>
>> ___________________________________________________________
>> Lon Orenstein
>> pinpointtools, llc
>> (E-Mail Removed)
>> Author of Outlook 2007 Business Contact Manager For Dummies
>> Author of the eBook: Moving from ACT! to Business Contact Manager
>> www.pinpointtools.com
>>
>>
>>
>> "Steve Maust" <Steve (E-Mail Removed)> wrote in message
>> news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
>> >I want to change the classification of 1000 leads by adding a check mark
>> >to
>> > the lead dialog box in the contact modify pane. Is there a provision in
>> > BCM
>> > or Outlook to change fields in records in bulk throug a query?

>>


 
Reply With Quote
 
=?Utf-8?B?U3RldmUgTWF1c3Q=?=
Guest
Posts: n/a
 
      24th Oct 2007
I cannot find any "group by box" in any tool bar. there is no help in BCM
online to tell you the process of setting up a group. The "new group" area
has no right click features. I cannot find any help to do these simple
operations. What do I do?

"Lon Orenstein" wrote:

> Sorry Steve... you have to change one record first, then when you group by
> the Lead field, you'll have two groups -- one with one contact in it that
> you just changed, and all your other contacts that were not changed.
> Highlight all the unchanged contacts and left click/drag them all to the
> Lead grouping. You'll see a little tooltip popup that says something like
> "Change value to Lead". Drop them on that grouping and the data will be
> updated.
>
> I'm 99% sure that there are longer instructions in this newsgroup also...
> it's been explained before.
>
> HTH,
> Lon
>
> ___________________________________________________________
> Lon Orenstein
> pinpointtools, llc
> (E-Mail Removed)
> Author of Outlook 2007 Business Contact Manager For Dummies
> Author of the eBook: Moving from ACT! to Business Contact Manager
> www.pinpointtools.com
>
>
>
> "Steve Maust" <(E-Mail Removed)> wrote in message
> news:C2EA6EC8-503E-4D57-AEEB-(E-Mail Removed)...
> > Thanks that partially answeres my question, I am looking to change the
> > classification of 1000 contacts so that the "lead" check box is checked so
> > the contacts will show in my "address card (leads)" view and they will be
> > seperated from my other business contacts. I cant find anyway to create a
> > group by contacts that have the lead box checked. Your further help would
> > be
> > appreciated
> > Steve
> >
> > "Lon Orenstein" wrote:
> >
> >> Steve:
> >>
> >> Here's what Judy wrote earlier in this newsgroup:
> >>
> >> group by whatever field you need to modify, for example State. To change
> >> a
> >> lot of Contacts' State at once, drag them from one state group to
> >> another.
> >>
> >> In case you don't know how to group: To group, turn on the Advanced
> >> Toolbar. Turn on the Group By Box. Drag the field header you want to
> >> group
> >> by, into the Group By Box.
> >>
> >> This works for changes of Company name as well. Group by Company field.
> >> Change one manually, then drag the rest into that group.
> >>
> >> HTH,
> >> Lon
> >>
> >> ___________________________________________________________
> >> Lon Orenstein
> >> pinpointtools, llc
> >> (E-Mail Removed)
> >> Author of Outlook 2007 Business Contact Manager For Dummies
> >> Author of the eBook: Moving from ACT! to Business Contact Manager
> >> www.pinpointtools.com
> >>
> >>
> >>
> >> "Steve Maust" <Steve (E-Mail Removed)> wrote in message
> >> news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
> >> >I want to change the classification of 1000 leads by adding a check mark
> >> >to
> >> > the lead dialog box in the contact modify pane. Is there a provision in
> >> > BCM
> >> > or Outlook to change fields in records in bulk throug a query?
> >>

>

 
Reply With Quote
 
Lon Orenstein
Guest
Posts: n/a
 
      24th Oct 2007
Are you running BCM 2007 or 2003?

Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(E-Mail Removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com



"Steve Maust" <(E-Mail Removed)> wrote in message
news:A731F43A-BFEB-4476-A45C-(E-Mail Removed)...
>I cannot find any "group by box" in any tool bar. there is no help in BCM
> online to tell you the process of setting up a group. The "new group" area
> has no right click features. I cannot find any help to do these simple
> operations. What do I do?
>
> "Lon Orenstein" wrote:
>
>> Sorry Steve... you have to change one record first, then when you group
>> by
>> the Lead field, you'll have two groups -- one with one contact in it that
>> you just changed, and all your other contacts that were not changed.
>> Highlight all the unchanged contacts and left click/drag them all to the
>> Lead grouping. You'll see a little tooltip popup that says something
>> like
>> "Change value to Lead". Drop them on that grouping and the data will be
>> updated.
>>
>> I'm 99% sure that there are longer instructions in this newsgroup also...
>> it's been explained before.
>>
>> HTH,
>> Lon
>>
>> ___________________________________________________________
>> Lon Orenstein
>> pinpointtools, llc
>> (E-Mail Removed)
>> Author of Outlook 2007 Business Contact Manager For Dummies
>> Author of the eBook: Moving from ACT! to Business Contact Manager
>> www.pinpointtools.com
>>
>>
>>
>> "Steve Maust" <(E-Mail Removed)> wrote in message
>> news:C2EA6EC8-503E-4D57-AEEB-(E-Mail Removed)...
>> > Thanks that partially answeres my question, I am looking to change the
>> > classification of 1000 contacts so that the "lead" check box is checked
>> > so
>> > the contacts will show in my "address card (leads)" view and they will
>> > be
>> > seperated from my other business contacts. I cant find anyway to create
>> > a
>> > group by contacts that have the lead box checked. Your further help
>> > would
>> > be
>> > appreciated
>> > Steve
>> >
>> > "Lon Orenstein" wrote:
>> >
>> >> Steve:
>> >>
>> >> Here's what Judy wrote earlier in this newsgroup:
>> >>
>> >> group by whatever field you need to modify, for example State. To
>> >> change
>> >> a
>> >> lot of Contacts' State at once, drag them from one state group to
>> >> another.
>> >>
>> >> In case you don't know how to group: To group, turn on the Advanced
>> >> Toolbar. Turn on the Group By Box. Drag the field header you want to
>> >> group
>> >> by, into the Group By Box.
>> >>
>> >> This works for changes of Company name as well. Group by Company
>> >> field.
>> >> Change one manually, then drag the rest into that group.
>> >>
>> >> HTH,
>> >> Lon
>> >>
>> >> ___________________________________________________________
>> >> Lon Orenstein
>> >> pinpointtools, llc
>> >> (E-Mail Removed)
>> >> Author of Outlook 2007 Business Contact Manager For Dummies
>> >> Author of the eBook: Moving from ACT! to Business Contact Manager
>> >> www.pinpointtools.com
>> >>
>> >>
>> >>
>> >> "Steve Maust" <Steve (E-Mail Removed)> wrote in message
>> >> news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
>> >> >I want to change the classification of 1000 leads by adding a check
>> >> >mark
>> >> >to
>> >> > the lead dialog box in the contact modify pane. Is there a provision
>> >> > in
>> >> > BCM
>> >> > or Outlook to change fields in records in bulk throug a query?
>> >>

>>


 
Reply With Quote
 
Steve M
Guest
Posts: n/a
 
      25th Oct 2007
On Oct 24, 4:55 am, "Lon Orenstein" <L...@pinpointtools.com> wrote:
> Are you running BCM 2007 or 2003?
>
> Lon
>
> ___________________________________________________________
> Lon Orenstein
> pinpointtools, llc
> L...@pinpointtools.com
> Author of Outlook 2007 Business Contact Manager For Dummies
> Author of the eBook: Moving from ACT! to Business Contact Managerwww.pinpointtools.com
>
> "Steve Maust" <SteveMa...@discussions.microsoft.com> wrote in message
>
> news:A731F43A-BFEB-4476-A45C-(E-Mail Removed)...
>
>
>
> >I cannot find any "group by box" in any tool bar. there is no help in BCM
> > online to tell you the process of setting up a group. The "new group" area
> > has no right click features. I cannot find any help to do these simple
> > operations. What do I do?

>
> > "Lon Orenstein" wrote:

>
> >> Sorry Steve... you have to change one record first, then when you group
> >> by
> >> the Lead field, you'll have two groups -- one with one contact in it that
> >> you just changed, and all your other contacts that were not changed.
> >> Highlight all the unchanged contacts and left click/drag them all to the
> >> Lead grouping. You'll see a little tooltip popup that says something
> >> like
> >> "Change value to Lead". Drop them on that grouping and the data will be
> >> updated.

>
> >> I'm 99% sure that there are longer instructions in this newsgroup also...
> >> it's been explained before.

>
> >> HTH,
> >> Lon

>
> >> ___________________________________________________________
> >> Lon Orenstein
> >> pinpointtools, llc
> >> L...@pinpointtools.com
> >> Author of Outlook 2007 Business Contact Manager For Dummies
> >> Author of the eBook: Moving from ACT! to Business Contact Manager
> >>www.pinpointtools.com

>
> >> "Steve Maust" <SteveMa...@discussions.microsoft.com> wrote in message
> >>news:C2EA6EC8-503E-4D57-AEEB-(E-Mail Removed)...
> >> > Thanks that partially answeres my question, I am looking to change the
> >> > classification of 1000 contacts so that the "lead" check box is checked
> >> > so
> >> > the contacts will show in my "address card (leads)" view and they will
> >> > be
> >> > seperated from my other business contacts. I cant find anyway to create
> >> > a
> >> > group by contacts that have the lead box checked. Your further help
> >> > would
> >> > be
> >> > appreciated
> >> > Steve

>
> >> > "Lon Orenstein" wrote:

>
> >> >> Steve:

>
> >> >> Here's what Judy wrote earlier in this newsgroup:

>
> >> >> group by whatever field you need to modify, for example State. To
> >> >> change
> >> >> a
> >> >> lot of Contacts' State at once, drag them from one state group to
> >> >> another.

>
> >> >> In case you don't know how to group: To group, turn on the Advanced
> >> >> Toolbar. Turn on the Group By Box. Drag the field header you want to
> >> >> group
> >> >> by, into the Group By Box.

>
> >> >> This works for changes of Company name as well. Group by Company
> >> >> field.
> >> >> Change one manually, then drag the rest into that group.

>
> >> >> HTH,
> >> >> Lon

>
> >> >> ___________________________________________________________
> >> >> Lon Orenstein
> >> >> pinpointtools, llc
> >> >> L...@pinpointtools.com
> >> >> Author of Outlook 2007 Business Contact Manager For Dummies
> >> >> Author of the eBook: Moving from ACT! to Business Contact Manager
> >> >>www.pinpointtools.com

>
> >> >> "Steve Maust" <Steve Ma...@discussions.microsoft.com> wrote in message
> >> >>news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
> >> >> >I want to change the classification of 1000 leads by adding a check
> >> >> >mark
> >> >> >to
> >> >> > the lead dialog box in the contact modify pane. Is there a provision
> >> >> > in
> >> >> > BCM
> >> >> > or Outlook to change fields in records in bulk throug a query?- Hide quoted text -

>
> - Show quoted text -


I am running 2007, Thanks in advance for the help.

 
Reply With Quote
 
Lon Orenstein
Guest
Posts: n/a
 
      25th Oct 2007
OK, Steve, do these steps:

1. Go to the Business Contacts view
2. Click on View, Toolbars, Advanced -- you'll see a new toolbar at the top
of Outlook.
3. Click on the Group By Box icon on the toolbar. You'll see the grid
display change to say "Drag a column header here to group by that column".
If the field you want to make mass changes to is showing in the grid, click
on it and drag it to that sentence and let go. That will change your view
to show contacts, grouped by that field.
4. If that field is not in the grid already, right click on the column
headers, and choose Customize Current View. Click on the Fields button. In
the top left dropdown "Select Available Fields From", choose User Defined
Fields in Folder. This shows you all the BCM fields in your database. Find
the field you want to make mass changes to, click once to highlight it, then
click Add to move it to the list on the right. Click on OK and OK again.
You should now see the field in the grid display and you can drag it to the
top of the grid as in step #3 above.
5. Your display is now grouped by that field. Assuming you have some
contacts with that value in that field and some without, you'll see two or
more groups. You can click View, Expand/Collapse Groups, Collapse All
Groups to make it easier to see which values are in that field.
6. If no records have the new value in them, you'll have to change one
record so that view can group by the new value. Expand one group by
clicking on the + sign. Double click on one contact record and change the
value to the value you want the other records to become.
7. Expand other groups of records that you want to change. Click on one
record to highlight it. Hold down the SHIFT key and click the last record
in the list you want to change, or hold down the CTRL key and click multiple
records that aren't together.
8. Drag the records into the area of the group with the new value you want
them to take on. You'll get a notice that says "Change {the field you're
changing} to {the new value}". Let go of the mouse and all the records will
now be in that group and their values will be changed.

Voila!

HTH,
Lon

--
___________________________________________________________
Lon Orenstein
pinpointtools, llc
(E-Mail Removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com



"Steve M" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Oct 24, 4:55 am, "Lon Orenstein" <L...@pinpointtools.com> wrote:
>> Are you running BCM 2007 or 2003?
>>
>> Lon
>>
>> ___________________________________________________________
>> Lon Orenstein
>> pinpointtools, llc
>> L...@pinpointtools.com
>> Author of Outlook 2007 Business Contact Manager For Dummies
>> Author of the eBook: Moving from ACT! to Business Contact
>> Managerwww.pinpointtools.com
>>
>> "Steve Maust" <SteveMa...@discussions.microsoft.com> wrote in message
>>
>> news:A731F43A-BFEB-4476-A45C-(E-Mail Removed)...
>>
>>
>>
>> >I cannot find any "group by box" in any tool bar. there is no help in
>> >BCM
>> > online to tell you the process of setting up a group. The "new group"
>> > area
>> > has no right click features. I cannot find any help to do these simple
>> > operations. What do I do?

>>
>> > "Lon Orenstein" wrote:

>>
>> >> Sorry Steve... you have to change one record first, then when you
>> >> group
>> >> by
>> >> the Lead field, you'll have two groups -- one with one contact in it
>> >> that
>> >> you just changed, and all your other contacts that were not changed.
>> >> Highlight all the unchanged contacts and left click/drag them all to
>> >> the
>> >> Lead grouping. You'll see a little tooltip popup that says something
>> >> like
>> >> "Change value to Lead". Drop them on that grouping and the data will
>> >> be
>> >> updated.

>>
>> >> I'm 99% sure that there are longer instructions in this newsgroup
>> >> also...
>> >> it's been explained before.

>>
>> >> HTH,
>> >> Lon

>>
>> >> ___________________________________________________________
>> >> Lon Orenstein
>> >> pinpointtools, llc
>> >> L...@pinpointtools.com
>> >> Author of Outlook 2007 Business Contact Manager For Dummies
>> >> Author of the eBook: Moving from ACT! to Business Contact Manager
>> >>www.pinpointtools.com

>>
>> >> "Steve Maust" <SteveMa...@discussions.microsoft.com> wrote in message
>> >>news:C2EA6EC8-503E-4D57-AEEB-(E-Mail Removed)...
>> >> > Thanks that partially answeres my question, I am looking to change
>> >> > the
>> >> > classification of 1000 contacts so that the "lead" check box is
>> >> > checked
>> >> > so
>> >> > the contacts will show in my "address card (leads)" view and they
>> >> > will
>> >> > be
>> >> > seperated from my other business contacts. I cant find anyway to
>> >> > create
>> >> > a
>> >> > group by contacts that have the lead box checked. Your further help
>> >> > would
>> >> > be
>> >> > appreciated
>> >> > Steve

>>
>> >> > "Lon Orenstein" wrote:

>>
>> >> >> Steve:

>>
>> >> >> Here's what Judy wrote earlier in this newsgroup:

>>
>> >> >> group by whatever field you need to modify, for example State. To
>> >> >> change
>> >> >> a
>> >> >> lot of Contacts' State at once, drag them from one state group to
>> >> >> another.

>>
>> >> >> In case you don't know how to group: To group, turn on the
>> >> >> Advanced
>> >> >> Toolbar. Turn on the Group By Box. Drag the field header you want
>> >> >> to
>> >> >> group
>> >> >> by, into the Group By Box.

>>
>> >> >> This works for changes of Company name as well. Group by Company
>> >> >> field.
>> >> >> Change one manually, then drag the rest into that group.

>>
>> >> >> HTH,
>> >> >> Lon

>>
>> >> >> ___________________________________________________________
>> >> >> Lon Orenstein
>> >> >> pinpointtools, llc
>> >> >> L...@pinpointtools.com
>> >> >> Author of Outlook 2007 Business Contact Manager For Dummies
>> >> >> Author of the eBook: Moving from ACT! to Business Contact Manager
>> >> >>www.pinpointtools.com

>>
>> >> >> "Steve Maust" <Steve Ma...@discussions.microsoft.com> wrote in
>> >> >> message
>> >> >>news:7FFA9C9F-0F80-4B70-8B25-(E-Mail Removed)...
>> >> >> >I want to change the classification of 1000 leads by adding a
>> >> >> >check
>> >> >> >mark
>> >> >> >to
>> >> >> > the lead dialog box in the contact modify pane. Is there a
>> >> >> > provision
>> >> >> > in
>> >> >> > BCM
>> >> >> > or Outlook to change fields in records in bulk throug a query?-
>> >> >> > Hide quoted text -

>>
>> - Show quoted text -

>
> I am running 2007, Thanks in advance for the help.
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Create Records and Append to Table biganthony via AccessMonster.com Microsoft Access VBA Modules 10 9th Aug 2007 03:58 PM
Importing groups of multiple records(Bulk) takeagoodlook911@yahoo.com Microsoft Access Form Coding 0 11th Jul 2007 02:09 PM
Speed up Bulk Insert Dataset records! Jay Balapa Microsoft Dot NET Compact Framework 1 28th Jun 2006 10:41 PM
Speed up Bulk Insert Dataset records! Jay Balapa Microsoft ADO .NET 1 28th Jun 2006 10:41 PM
Bulk updating records/rows whilst STILL in DataSet? Mike Kingscott Microsoft ADO .NET 1 29th Sep 2004 04:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:20 AM.