OpenOffice: How to Mail Merge Address Labels from an Excel Spreadsheet


(1) File -> Wizards -> Address Data Source …
(2) Select Other External Data, then click Next
(3) Click Settings
(4) When prompted for Database type, select "Spreadsheet" and click Next
(5) Press Browse and find the file you want to use, then click Open
(6) Press Test Connection
(7) Click Finish
(8) Don't worry about Field Assignment, click  Next
(9) Give your address book a name and file location (for the database file)
(10) Click Finish
(11) File -> New -> Labels
(12) Select Database and Table
(13) Select and insert fields (using arrow) in order
(14) Select label type
(15) Click New Document
(16) Click Print
(17) When asked if you want to Print a Form Letter, click Yes
(18) Select output to Printer or File
(19) Press OK

Comments