Excel Import Option: Need Help Updating Existing Records

Status
Not open for further replies.

KFarchmin

New Member
Outlook version
Outlook 2010 64 bit
Email Account
I’m working to clean up my 2010 BCM database and update e-mail opt outs from my Constant Contact account, etc., which is very time-consuming going contact-by-contact.

That being said, I have a long list of opt outs from my Constant Contact account. I would like to go in and update each contact by importing that Excel list into the BCM, and “updating” the existing contacts, and changing their marketing “status” to OPT OUT (a custom field).

From the tutorials I’ve seen and the demonstrations I’ve watched, I think my BCM 2010 is missing the option to “update”. Attached is a screenshot of the import options I'm given.

Even the “help” section of Outlook (http://office.microsoft.com/en-us/o...ontact-manager-HA010379389.aspx#_Toc251157634 ) shows a screenshot with the “update” option. (in attached file).

Can you help? I don’t want to waste my time updating each record if there’s a way to do a bulk edit by importing the list.
 

Attachments

Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
T Outlook Calendar 2016 import Excel Using Outlook 1
B Import Excel Text into Outlook Calender Using Outlook 4
ogodt Change Default contact form and import from Excel 2010 Using Outlook 1
B Problem with import Excel BCM (Business Contact Manager) 1
F import individual contact info from excel to outlook contacts or vice versa Using Outlook 2
N Import Contacts Excel CSV File into Outlook 2010 Using Outlook 2
N When I try to import a large CSV from Excel to an Outlook folder, the program crashes... Every time. Using Outlook 2
L Import contact updates from Excel Using Outlook 1
C Way to import contacts from Excel into BCM Contacts? BCM (Business Contact Manager) 1
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
S How to export urls from email to excel and check the status of the url ? New Slipstick.com Articles 6
S save email from excel Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
E Accessing shared outlook folder doesn't work since switch to new outlook/excel Outlook VBA and Custom Forms 11
E Copying the whole e-mail body into excel Outlook VBA and Custom Forms 0
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
S Find a cell value in excel using outlook vba Using Outlook 1
K Update Appointment category when changed in Excel Using Outlook 3
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
D Paste Excel table into Outlook message Outlook VBA and Custom Forms 6
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
D Retrieving Tables from outlook to excel Using Outlook 14
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
N Export details to a excel spreadsheet using macros Using Outlook 0
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
N Lookup Value From Excel and Reply With Matching Value Using Outlook 0
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
Diane Poremsky Importing Lists from Excel to Outlook New Slipstick.com Articles 0
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
M Linking Excel Cell to Shared Contacts Outlook VBA and Custom Forms 7
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
A How to export one email data to excel Using Outlook 1
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
A Populate Excel from Outlook Userform Outlook VBA and Custom Forms 3
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
Similar threads


















































Top