This information will be helpful to create many Certified Mail Labels using Excel or other types of CSV data files.
The process is fast and easy, but some new users can make errors because they do not format the data correctly in the Excel format. Please carefully review the Excel Batch Labels template attached prior to uploading and processing. Remember the old computer saying…
Garbage In = Garbage Out!
The process is fast and you can spend lots of money if you do not follow it carefully. For that reason we ALWAYS RECOMMEND YOU RUN 3 OR 4 LABELS PRIOR TO UPLOADING A LARGE MAILING LIST.
Remember you cannot ‘Go Back’ or Undo… So please check your work carefully prior to using the Excel Batch Labels feature.
Common Mistakes:
1. Not filling out the Excel sheet correctly. Download this file example and review the file specifications. Pay attention to field length, no special characters, symbols, etc
USPS DOES NOT SUPPORT SPECIAL CHARACTERS: @ / \ ! ; ( ) % $ * and more. Your label will fail if you try to use a non-supported character.
2. Quality Control. Repeat step 1 and check for errors. (Repeat Step 1)
3. Not saving your data into a proper format. CSV, XLS or XLSX. MAKE SURE YOU ONLY HAVE 1 WORKBOOK IN THE FILE. DO NOT INCLUDE HIDEN OR FILTER DATA, HIGHLIGHTED OR INCLUDE MULTIPLE SHEETS LINKED TOGETHER.
4. Don’t get distracted with other work tasks. Check your work, then check it again prior to approving the job to process.
