Forum Discussion

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

Excel - Word - 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!

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jan 31, 2019

    Hi Alison,

     

    Column IV is #256. Usually queries in office have 255 columns limit, as I remember Mail Merge is not an exception.

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

      Hi Sergei,

       

      Yep it's 256 going all the way up to 362.  That's a bummer to say the least - would you know anyway around that?

       

      Thank

      Alison 

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jan 31, 2019

        Nope, sorry, I don't know workaround, work with Mail Merge once per few years. Do you really need all these 362 fields, perhaps you may modify your source to reduce number of fields?

Resources