[NTLUG:Discuss] DB help

[Robert Citek]

On Wed, Apr 9, 2008 at 12:12 PM, Fred <fredstevens at yahoo.com> wrote:
> I have a list of names, addresses and other data in a spreadsheet
>  (OpenOffice calc, one field per column) and I am trying to figure
>  out how to make mailing labels from that data. A complicating factor
>  is that street numbers, names, types (dr, ave, etc) and direction
>  are all different columns and need to be concatenated into one
>  "address" field. ex: 1234 Main St W is in Calc as 4 separate
>  entries, "1234", "Main", "St", "W".

Is it always four (4) fields?  Can you post a few sample rows that
show the variability of the data?  How many rows of data are there?

Once you have the data in a consistent format, then it's a matter of
using the Mail Merge feature in Writer.

Regards,
- Robert