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

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