Click2Mail Troubles

[Steven J.]

I'm trying my first mailing with click2mail and I'm extremely frustrated. Now that I've finally gotten over how frustrating it was just to get the postcard formatted correctly now I'm stuck with my mail merge. Customer care wasn't much support so I'm hoping others can help out.

I'm trying to customize the mail merge field. I've got a list of properties I want to mail to. I broke out my excel sheet so there was a column for 'address #', 'street name' 'type of street' and 'direction.' Since I've seen other programs provide lists in such a format I thought this would work. When I import it I'm unable to add all those as needed. All I'm allowed to add is the full address rather than the individual parts. In other words, when it uploads I have and address that reads

Mary Anderson Dan Anderson
510
Moorhead, MN 56560

There has got to be an easier way to get it to read better right? I want to get:

Mary & Dan Anderson
510 Main St.
Moorhead, MN 56560.

I understand the editing of the names is a go through every label kind of thing, but how do I get the address correct? Is it a Google Chrome issue? Does their new beta pro not work well?

[Rhonda E.]

It is probably your column headers and/or how you have input the data into your Excel file. Just make sure to save the file as CSV. Check the CSV file after you have saved it to make sure that Excel is saving correctly. If not, the problem could be due how you have the cells formatted in Excel.

My columns are as follows:

First Name

Last Name

Mailing Address

City

State

Zip Code

Property Address

I use two addresses, because I use the mail merge feature.