Part 1: pdf to excel

  1. Download the NU pdf file: Download
  2. Search by 'pdf to excel' and go to 'pdf2go.com' and convert to excel
  3. Open the merged excel>Enable editing; Remove all rows for title (carefully notice the line after each title if a single line was broken to two line or not); Select all rows and columns>Unselect 'Merge & center' from Home menu
  4. Select Data>Filter; Now filter dropdown will appear in each column
  5. First dropdown>Unselect Blanks
  6. Now copy the full filtered sheet to a new one
  7. Create two blank rows after the first row
  8. Select first column>Data>Text to Columns>Delimited>Next>Other '/'>Next>Finish

Part 2: excel to seat card

Considering you have a excel file with student list

  1. Mailings > Start Mail Merge > Labels (30 per page)
  2. Display all borders
  3. Write your labels:
    Name:
    Roll:
  4. Mailings > Select Recipients > Use an existing list (browse to select your excel file)
  5. Mailings > Insert Merge Field > choose and insert your labels
  6. Mailings > Update Labels
  7. Mailings > Finish & Merge > Edit Individual Documents > ok

Part 3: 6x2 A4 Custom Layout

  1. New page > Layout > Margins: 0 > Size: A4
  2. Insert > Table (6x2) > Right-click table > Table Properties > Options > Check 'Allow spacing between cells' (0.1) > OK
  3. Select table > No Border > Inside Border

Part 4: Custom Label Dimensions Setup

Update fields in this precise sequence to prevent Word errors:

  1. Mailings > Start Mail Merge > Labels > New Label
  2. Page size > Select A4
  3. Number across: 2 > Number down: 6
  4. Top margin: 0.01" > Side margin: 0.01"
  5. Label height: 1.84" > Label width: 4.02"
  6. Vertical pitch: 1.94" > Horizontal pitch: 4.12" > OK

Part 5: Mail Merge to Generate Mass Labels

  1. Mailings > Select Recipients > Use an Existing List (browse to select your excel file)
  2. Mailings > Insert Merge Field > Choose and insert your labels into the first box
  3. Mailings > Update Labels (copies layout across the entire page)
  4. Mailings > Preview Results (check your work)
  5. Mailings > Finish & Merge > Edit Individual Documents > OK

Labels: ,

✏️ Edit This Post