- I don't know what program to send my order in?
- Can you format my database for me?
- I don't know how to format my mailing list?
- I have multiple groups to send to... How should I separate them?
- How do I send my addresses through the order form?
- How does Chalk Line handle address corrections?
If you submit an address block, we must have it correctly formatted so that the cell wraps the information on individual lines. It is more and more common to see address list where there is information that is intended to wrap but ends up all in one line like so:
In order to fix this issue, there is a helpful shortcut we use ourselves: Place your cursor where you would like to enter your line break in the cell. If you are using Excel on PC, hold down the "ALT" key and press "ENTER". If you are on Excel for Mac, hold down "CTRL" + "ALT" and press "RETURN". If you are using Numbers, hold down "OPTION" and press "RETURN". This will move the information to the next line within the cell (not the next cell).
Another common issue that can cause confusion is sending a list with multiple sheets. We do prefer that all orders are accompanied by only one address list with only one address sheet. If you have multiple groups or multiple sheets, these groups need to be separated into single sheet databases and submitted as separate orders. If you have a column in your spreadsheet that indicates what group to send to (such as a "Send Newsletter", or "A/B groups"), please sort before you send so that we receive ONLY the people you want to mail to.