I need to print a directory of an Excel file. I have 15 fields that I want to print. There are only 13 fields shown in the list of fields to select. How can I get the other two fields to show up on the list to print?



Nancy

I have 16 columns in my Excel Document. I use 13 of those columns to print labels. I want to print a membership directory using 15 of the 16 columns. Using Insert Merge Field I can only access 13 columns. I tried to use Match Field, but that only accesses 13 columns. How can gain access to the other two columns?

Why do I seem to be the only person limited to 13 columns in mail merge?

OK, I moved the rows around so that I didn't have to type in the phone number and e-mail addresses. I would only have to type in two columns one of 3 digits the other one 1 letter.

So now in mail merge instead of 13 columns I now have 11. Still do not have the phone number of e-mail addresses. Can anyone please tell me what is happening and how I can fix or avoid it?

I don't want to have to type in 280 names, addresses and other information.

Hi Nancy,

Do all the fields have heading names?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Someone helped me to transfer the database to Access 2007. The mail merge function works exactly the same as it does with Excel. That solved my problem. I still don't know what was wrong with the Excel database.

Nancy