Changing the Excel sheet in mail merge

T

Travis

When attempting to change the sheet that is used from an excel 2007/2010
(xlsx) file in mail merge in Publisher 2007 and 2010 technical preview, (by
selecting Edit Recipient List > Select an existing list), I get the message
that the file is already open. However if I am using an excel 2003 (xls)
file, it works fine and asks me which sheet I want to select.

Is there a way to change the sheet being used in an xlsx file, or do I need
to save all of my worksheets in an older format?
 
M

Mary Sauer

Did you ask if this is a bug on the Connect web site? If the merge works when
you save the Excel file to .xls, then, for now this is your solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Mail Merge Directory Conditional Page Break 0
Save workbook without shapes 0
Autonumber field in Excel that behaves the same as Access 0
Update several ppt documents from a single excel file 0
Doughnut Chart linked with the slicer in the pivot table 0
Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3

Top