How to set custom field to blank for many contacts... - Constant Contact Community

user08788 · ‎03-14-2024

I have a custom field that has an incorrect value for many contacts (say, around 1000). Rather than keep the field's incorrect values, I want to set values to blank. My usual tool for bulk updating is using an Excel spreadsheet in Add Contacts. However, that approach does not work because blank fields are ignored. Is there a way to specify that field values should be set to blank rather than ignored? I can update contacts one by one, but I have too many contacts to fix.

William_A · ‎03-14-2024

Hello @user08788 ,

The only real way to clear them would be to wholly delete the custom field, or replace the custom field info with something more generic like "null" or "n/a."

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

How to set custom field to blank for many contacts?

Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

Casual Conversations: What's your go-to playlist?

Ready, Set, Send Challenge Week 6: List Management and Segmentation

Just Getting Started?

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.