8 per sheet labels, excel sheet with addresses...

[AstroTurf]

8 per sheet labels, excel sheet with addresses... Help Please?

Hi,

I have several thousand addresses in an excel sheet in the following format
Row1 Name. Row2 Address line1 Row3 Address line 2. Row4 Address line 3. Row4 Country.

Any way that I can get these automatically formatted into 8 per sheet label type docs or should I just carry on copying and pasting into word? (My word doc template I am using has 8 text boxes in it in the right alignment for the labels).

I have office 2010 and libreoffice(open office).

Thanks

 

[Venomous]

Have you tried converting your info to Access & then importing the lines into word?

(can be auto done)

 

[SirFooK'nG]

I would also look at importing it into Access, then just write a report that looks like the Word Document...

 

[biena]

why not just use mail merge ? pretty sure that would work

http://wiki.services.openoffice.org...Merge_Documents_From_Text/CSV_or_Spreadsheets

 

[AstroTurf]

http://support.microsoft.com/kb/318117

Yep, used mail merge, worked a charm, thanks