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
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

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Feb 01, 2019

        Alison, thanks for sharing. I'm surprised what from csv file you may merge 362 fields

Resources