We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can I put a sequential number on a mail merge label? [closed]

asked 2014-01-23 12:43:11 +0200

rertini gravatar image

updated 2014-01-24 16:47:32 +0200

What I did:

1- on Writer I connected to Biblio table.

2- inserted two mail merge fields (ie.: Author & Title).

3- Inserted Record Number Field.

4- File > Print.

5- Answered Yes to "Your document contains address database fields. Do you want to print a form letter?"

6- Selected All records (or some of them).

7- Sent to Printer (or to File).

Result: Correctly dispayed data of the recods selected, but the record number is the same on all labels.

Tried with other types of databases and/or using the Mail Merge Wizard with the same result.

Is there another way to number the labels sequentially?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-25 18:36:18.723363

1 Answer

Sort by » oldest newest most voted

answered 2015-09-26 22:54:10 +0200

Mountain gravatar image

Thanks to pierre-yves samyn , here is the answer:

Create a spreadsheet including the sequential numbers for your "Record Number" field (say 1 to 1000):

  • File New Spreadsheet
  • Type e.g. RecordNum in A1 (field title)
  • Click in the Name Box (left of formula bar),
    • type A2:A1001
    • Enter to select the range
  • Edit Fill Series:
    • Start Value 1,
    • End Value 1000,
    • Ok
  • Define this spreadsheet as source of mailing in your writer document: Edit > Exchange Database
  • Insert the RecordNum field in the header:
    • Drag & drop from the Data Sources view OR
    • Insert Fields More Fields, Database tab
  • Launch mailing and proceed as you did before
edit flag offensive delete link more

Question Tools



Asked: 2014-01-23 12:43:11 +0200

Seen: 2,237 times

Last updated: Sep 26 '15