Sequencing of mail labels printed from spreadsheet

Writing a book, Automating Document Production - Discuss your special needs here

Sequencing of mail labels printed from spreadsheet

Postby BOBBYGv » Sun Jul 29, 2018 2:21 am

I've have finished producing address labels from a mail merge with a spreadsheet. However the print preview shows what appears to be a random order of labels rather than starting with the first row as the first label (actually started at row 113?). I haven't found any discussions about sequencing the labels on the writer document.
Apache Open Office 4.1.5 Windows 10
BOBBYGv
 
Posts: 1
Joined: Sun Jul 29, 2018 2:00 am

Re: Sequencing of mail labels printed from spreadsheet

Postby John_Ha » Sun Jul 29, 2018 11:32 am

On printing, labels (assuming 4 wide) sequence
...
17 18 19 20
21 22 23 24
...
according to the sequence of rows 17 18 19 20 21 22 23 24 selected in the spreadsheet.

Search the Writer forum with labels or mail merge for many posts.

As a new poster you will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages. See Chapter 11 - Using Mail Merge

Press F1 to access the Help screen and search for your problem

The chapter headings in the manual are:

1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6649
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Advanced Uses

Who is online

Users browsing this forum: No registered users and 2 guests