Bulk change "active" to "inactive"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure how it happened; maybe in connection with Quickbooks data
migration; anyway, I ended up w/ all my business contacts "active," and I
need to make about 600 of them "inactive." Is there any convenient way to do
this?

Thanks in advance . . .

David Rowell

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-307ceead74ab&dg=microsoft.public.outlook.bcm
 
Thanks for the question. One way to do it is, In Business Contacts folder,
change the folder view to [By Active] and drag the contacts from 'Active:Yes'
grouping into 'Active:No' grouping. You can drag all contacts together. But
dragging 600 contacts might slow down outlook, instead do it in batches of 50
or 100.

I hope this answered your question.

Thanks,
Vamshi [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights
 
This is far too late to help with the problem you posted, but I hope it saves
you some un-necessary work in the future.

I have a suggestion which is based on years of failing to get Quickbooks to
integrate with other programs including Quickbooks Customer Manager -
Folk such as I who buy these straight out of the box programs are generally
not trained in I.T. and as such we expect more compatability than we actually
get...
We also come up with interesting side-steps to help us get our money's worth.

From within Quickbooks, create a report based on your customers / jobs which
mirrors the customer:jobs list.
I'll assume that your inactive customers all have an X at the left hand side
when you tick the "Show All" box at the bottom of the screen in the
Customer:jobs list which is accessed by CONTROL + J.
If this is the case then the report you generated will not show the inactive
entries.
You can now export this as a CSV file by "printing" it to a file rather than
a printer & choosing .CSV as the format.
Use this CSV file as a translator for sending your Quickbooks data to other
programs.
I tried working with IIF files, it's a lot of extra work for little or no
extra result.
My latest approach is to make changes to customer data only in Quickbooks at
the base level, i.e. within the customer records as I've found Quickbooks to
be very stable & predictable.
I'm now using it's internal Report functions to export the changes as CSV
files.
Hope this is useful.

Vamshi said:
Thanks for the question. One way to do it is, In Business Contacts folder,
change the folder view to [By Active] and drag the contacts from 'Active:Yes'
grouping into 'Active:No' grouping. You can drag all contacts together. But
dragging 600 contacts might slow down outlook, instead do it in batches of 50
or 100.

I hope this answered your question.

Thanks,
Vamshi [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights


David Rowell said:
I'm not sure how it happened; maybe in connection with Quickbooks data
migration; anyway, I ended up w/ all my business contacts "active," and I
need to make about 600 of them "inactive." Is there any convenient way to do
this?

Thanks in advance . . .

David Rowell

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-307ceead74ab&dg=microsoft.public.outlook.bcm
Click to expand...
Click to expand...
 
Back
Top