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 wor...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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
    Diamond Contributor
    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?

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

      Thanks Sergei,

       

      I could look at separating them into different sheets but that complicates it somewhat -I tried doing that and needed to use paste link but it slowed the whole merge down and kept crashing both word and excel.

       

      I appreciate your help though.

       

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

        Hi Sergei,

         

        Just letting you know I've had a solution - exporting the file to csv and merging that way seems to have done the trick.

         

        Really appreciate your help.

        Cheers

Resources