adding corresponding contact form data on a mass scale

mr_malkovich

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
This one is a doozy. I've been throwing you problems for years but this one is rough.

Just imported 4.5k contacts from a csv into outlook forms. Custom outlook forms I created.

The csv has a column called Genre which we mapped to User1 in the contact forms. Once the forms were created we ran your code (much appreciated as always) to move the data in that User1 column to a custom field I created called Genre.

I did a ton of cleanup and work on these contacts before I noticed that the code had only made it into the Genre fields of less than one fifth of the total number of contacts. The code did manage to erase all the data from the User1 fields, so no chance of running it again and fixing it that way.

So now I have 4.5k contacts I've worked a long time on, but are missing crucial information in each. All that info is in the csv, sitting next to the rest of each contact's info. What do you think is the quickest way to add the data in the Genre column to their corresponding Outlook contacts?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I would re-import and remove the code that clears the user1 field. That would likely be the fastest since you won't need to write code to look up the values on the csv. Move the previously imported ones to a new folder or delete them.
 

mr_malkovich

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Are you basically saying start all over again? I'm hoping there's a way to marry that data with those contact files I created since I worked so hard on them. I figured there might be no way though. Is that the case?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
its not so much that there isn't another way - but if the csv has all the data, it might be the easiest.

The other way is a excel macro that looks up the contact (or an outlook macro that finds the entry on the csv) and adds value to the field. The only problem with this is writing and testing it. I don't have any that do anything close to this - that's not to say there isn't one floating around the net - but even so, tweaking and testing can add a few hours.

I'm not sure which would be faster, but would lean to doing it in excel as the most efficient way - work down the rows. look the contacts up by address and add the value.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you need one to mark contacts as unsubbed - it would be much to change the same macro to go through and add the field.
 
Top