Update contacts in BCM via new import

Status
Not open for further replies.
K

Ken

Hello,
I have 6,000+ new contacts in BCM all marked as "Active". About ~20% of
these contacts are going to be dead accounts. I use iContact for my email
marketing. iContact gives me a list of dead contacts after a marketing
campaign, exportable as a .CSV file.

How can I leverage this list of over 1,000 dead contacts update my existing
contacts to toggle the property value of "Active" into "InActive"?

Thanks
 
K

Ken

Ugh, I did this manually last week.
- Changed ~400 contacts from "Active" to "Inactive"

So far, I should have just stayed in Access or Excel for managing my
contacts. In total, I'll have another 3,000-ish contacts to edit in this
manner and do not look forward to the task. I am about to export my contact
database back into Excel, Delete all BCM contacts, perform my edits in Excel,
and then re-import. Seems like I'm missing out on some functionality here
beyond becoming a SQL DB admin.

Any help would be appreciated.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
Diane Poremsky Update Contacts with a New Company Name and Email Address Using Outlook 0
Diane Poremsky Update Contacts with a New Company Name and Email Address Using Outlook 0
M Address book doesn't update contacts? Please any help would be great! Exchange Server Administration 4
L Cannot update Location field in Contacts - Runtime Error 438 Using Outlook 0
P Outlook 2007: Update the Contacts folder entries Outlook VBA and Custom Forms 2
F Macro to update imported contacts Outlook VBA and Custom Forms 6
R Outlook 365 update sets delete from server flag Using Outlook 1
V Update new custom field Outlook VBA and Custom Forms 5
P Outlook 2019 UI changes after 20H2 update Using Outlook 1
D Change Microsoft Account password - what to do to update on all devices Using Outlook 4
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
C Not sync folders not found after MS Outlook 365 update Using Outlook 1
W September 2020 - No Default Email Client message after Office Update Using Outlook 1
D.Moore VBA script fail after Office 365 update Using Outlook 8
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
Jennifer Murphy Grant R/W (update) access to a friend Using Outlook 3
L Favorites don't update Using Outlook 1
F Copy and replace not update contact in another pst Using Outlook 0
M Message list font changed after update Using Outlook 2
M Quicken One Step Update Bill Reminders Not Syncing to Outlook Using Outlook 1
O Windows 1803 update : QAT and toolbar changed, language pack gone... Using Outlook 5
J Updating existing entry on shared calendar wants to send update from delegate Using Outlook 0
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
K Update Appointment category when changed in Excel Using Outlook 3
V Outlook 2003 problem with Windows 10 Creators Update 1709 Using Outlook 0
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
K Update subject based on text in body Outlook VBA and Custom Forms 3
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
M Recent Update Did not Fix Search Problems Using Outlook 7
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6
C Update Notes for Meeting Attendees Using Outlook 8
A Attendee Update Outlook Meeting Invite Using Outlook 0
Diane Poremsky Outlook Email Security Update Using Outlook 0
S Task Update coming as email and not updating task Using Outlook 3
Diane Poremsky Remove Office 2013 Update Banner Using Outlook 0
B IMAP folders don't update when Outlook 365 opens Using Outlook 0
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
Diane Poremsky Task Request Status Update Address Missing Using Outlook 0
Christopher M Importing from Eudora Update Using Outlook 5
Cameron Piper Automatically update custom forms across multiple computers Outlook VBA and Custom Forms 1
M Update field codes when opening Outlook Template Outlook VBA and Custom Forms 2
Bachelle Macro to Update Existing Task from New Email Outlook VBA and Custom Forms 3
I Microsoft Security Update KB3097877 Using Outlook 14
S Outlook 2010: October 2015 Update Using Outlook 0
S Outlook 2013: October 2015 Update Using Outlook 0
F Update the notes field Exchange Server Administration 0
A BCM crashes after Windows 10 update BCM (Business Contact Manager) 1
H SQL update column BCM (Business Contact Manager) 0

Similar threads

Top