Bulk Mailer
Once you have opened Bulk Mailer, the following steps will allow you to get the "Zip+4" for everyone in the data set.
A "Zip+4" code uses the basic five-digit Zip code plus four additional digits to identify a geographic segment within the five-digit delivery area. When we ship things using UPS we need to provide this information.
Direct Mail Checklist
*New Mailing Wizard*
*Next*; Make sure that “Create a Blank Mailing” is selected
*Next*; rename file to [First 4 #’s of Job ID]_JobType.bmf
*Finish*
*Import/Export Wizard* 🡪 *Import Wizard*
*Next* 🡪 *Select File*; then navigate to \\nas\groups\Data Entry\2-Ready for Upload
Choose the correct file and open it
Click next 3 times until you reach the Field Mapping Screen (Scroll down for Import fields)
*OK* 🡪 *Next* 🡪 *Finish*
Make sure that the number of records matches your data, then hit close
*Views* 🡪 *Basic Address* and scan for obvious misses
*Address Quality* 🡪 *Move Update* 🡪 *Next until Finish*
*Accept*; Scan through each error and fix obvious ones
*Close*
*Import/Export Wizard* 🡪 *Export Wizard* 🡪 *Next* 🡪 *Save As* 🡪 Find in Ready For Upload
Select file name & add “_Zip+4.csv” and save to desktop
*Save* 🡪 *Next* 🡪 Export Fields; Make sure that fields are mapped correctly
Click next until finish
File will save to desktop 🡪 *Close*
Add the correct headers to your new file
Field Mapping
Import Fields
Email1 🡪 Email
**Email2 🡪 User Phone 1
Grade 🡪 User Text 1
Student_ID 🡪 User Text 2
Background 🡪 User Text 3
**Teacher 🡪 User Text 4
**Validation 1 🡪 User Text 5
** = Optional Field (Only if present in source data)
Order of fields in Export
Last name
First name
Grade
Student_ID
Email
Email 2 (If Necessary)
Address Line 1
City
State
Zip
Background
Teacher
Validation1
Validation2
**Any other User Text fields will be placed after validations**