I would like to use Pages to send out invoices and form letters to my membership database which is in Excel. Is there a way to do this? Thanks.
OS X Mavericks (10.9)
No.
Pages 5 doesn't do mail merge at all. You would have to use Pages 4.3 & Numbers 2.3 for mail merging. Open the Excel file in Numbers, convert the top row to a header row & then set up your merge in Pages.
Thanks, Peggy. Opened my older version (4) of Pages, imported the data from Excel to Numbers but was getting an error message abou the header row that I didn't understand. So I converted the database to a csv and imported it into Contacts and was finally able to print the document and envelopes. Whew!
I'm glad you got it to work. I did mention converting the top row to a header row. It's a common error & the solution isn't at all clear. Here's what I wrote some time ago:
You need to designate a row as a header row in the Numbers table. Imported spreadsheets don't mark the first row as a header row. If the top row does contain the labels, hover the cursor over the row number, click the down-facing arrow that appears & choose convert to header row. If you don't have a row with labels to convert, add a header row using the Table menu or click the icon (middle icon) in the format bar then type in the labels.
Thank you so much for telling me how to do this. The error message was confusing and I don't think I ever would have figured that out on my own.
Can I do a mail merge from Excel in Pages?
