addresses

[Lapchien]

Guys, I have a listing of names and addresses:

Line 1 - name
Line 2 - street
Line 3 - area
Line 4 - town
Line 5 - town
Line 6 - post code
Line 7 - null
Line 8 - name
Line 9 - street
....etc...

All in one column in a table. I need to make address labels for these - one
thought is to have a bit of code that deletes all rows, except the 8th row,
to just leave the names - I could then copy the names to a new table column
called 'names', then repeat for the 9th row 'street', 10th row 'area' etc..?

Any help would be much appreciated as always.

Thanks,
Lap

[Pieter Linden]

"Lapchien" <no**@m.com> wrote in message news:<10***************@ananke.eclipse.net.uk>...

Guys, I have a listing of names and addresses:

Line 1 - name
Line 2 - street
Line 3 - area
Line 4 - town
Line 5 - town
Line 6 - post code
Line 7 - null
Line 8 - name
Line 9 - street
...etc...

All in one column in a table. I need to make address labels for these - one
thought is to have a bit of code that deletes all rows, except the 8th row,
to just leave the names - I could then copy the names to a new table column
called 'names', then repeat for the 9th row 'street', 10th row 'area' etc..?

Any help would be much appreciated as always.

Thanks,
Lap

Never tried it, but you might be able to open the table as a recordset
and then use the Split function and then populate fields in your table
with the elements of the array the Split function creates.