Eliminate the AutoMergeField(s) in a Mail Merge Document

When I use the "Insert Merge Field" option in Mail Merge I have 95 new "AutoMergeField" fields.   I have deleted, the blank columns in the Excel data file and I have also used "Clear All" to attempt to clear them but Word still thinks there is something in the column.  The Excel data is in A1:AV68  but the Word File is look at A1:HZ104.   Is there a cache that needs to be cleared in WORD or other way to eliminate them?

Any help would be appreciated,
Thanks,
Jerry
AutoMergeFields.png
LVL 16
Jerry PaladinoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lwebberCommented:
In Excel, define a name that includes just the columns you want to use. In Word, when you designate the Excel workbook as the data source, choose the name you defined. That should limit Word to using just the columns you included in the Excel defined name.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jerry PaladinoAuthor Commented:
Yes - That works  --  Thank You!
Jerry
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.