[NTLUG:Discuss] DB help

[Geoffrey Climer]

On Wed, Apr 9, 2008 at 1:58 PM, Robert Citek <robert.citek at gmail.com> wrote:

> 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
>
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
>

I've had to do something similar, though the address was all in one
column, but I found these two links very helpful:

http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1162261,00.html

http://openoffice.blogs.com/openoffice/2006/02/mail_merge_labe.html

-- 
Geoffrey