Proper Case in Data Import

Open Letter Connect does NOT automatically apply proper casing to your data. This means that, however your data is formatted when you import it, it is exactly how it will appear in the system and on your mail pieces.

For example:

• If you import JOHN SMITH, it will stay as JOHN SMITH.

• If you import john smith, it will stay as john smith.

What this means for you:

• In OLC, you control the formatting of your data before import.

• If you want names and addresses to appear in proper case (e.g., John Smith), you’ll need to prepare your data that way prior to upload.

Quick Tip: In Excel or Google Sheets, you can use the =PROPER(A1) formula to convert text in a cell (like john smith) into proper case (John Smith). Apply it to your name and address columns before exporting your file for upload into OLC.