Forum Discussion

Alison Flynn's avatar
Alison Flynn
Brass Contributor
Jan 31, 2019

Mail Merge not picking up fields from excel

Hi guys,

 

I've a pretty large database in excel that's being used to merge to a mail merge doc.  The database stretches to column MX but word is only picking up to column IV.

 

How can I get word to pick up the rest of the data as I need it in the mail merge document?

 

Thanks for helping!

word
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Feb 01, 2019

    Hi Alison Flynn 

     

    My understanding is that there's a limit to the columns. Seems to be that a comma delimited file may work or at least by knowing the column name you may be able to still insert it.

     

    I haven't found any clear reference on a definite solution but maybe give the top two suggestions a try?

     

    You have a huge file so it's certainly outside the normal rules!

     

    Best wishes and good luck!

     

    Cheers

    Damien

    • Alison Flynn's avatar
      Alison Flynn
      Brass Contributor
      Feb 01, 2019

      Hey Damien,

       

      Thanks a million for replying - looks like the csv has done the trick.

       

      Yes it's a big baby of a file!  Keeping me busy.

       

      Really appreciate your input.

      Cheers

Resources