list data formatting

[Clayton P.]

Hey guys,

I'm about to purchase a list from LS, and there's a good 15+ cells of info in their data per lead - which is great - but for my needs it makes it hard because I'll be printing both my letters and envelopes via mail merge, which means I have to have a preset order of cells at the very top of the spreadsheet, i.e. 1) homeowner name 2) mailing address 3) city state zip.. etc. The way their list is previewed, I'd have to go through 2000+ names, each with 15+ cells, and drag & rearrange into an order I can use with the mail merge. Nooo thank you.

If it was a free list, I couldn't ***** and moan, just grin and bear, but if its something I'm paying for, I want it the way I need it.

Any ideas how to do this? Both my account admin & general customer service won't respond. Or some other way to setup the mail merge by handpicking the cells? ugh. headache.

If I'm being kinda cloudy on my description here, sorry, its hard to describe I guess but if anyone has worked with any sort of mail merge software that imports from a spreadsheet, you'll probably get what I mean.