Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2016, 08:57 AM
Fabulist Fabulist is offline How to link Excel fields with MergeField in Word? Windows 10 How to link Excel fields with MergeField in Word? Office 2016
Advanced Beginner
How to link Excel fields with MergeField in Word?
 
Join Date: Sep 2015
Posts: 33
Fabulist is on a distinguished road
Default How to link Excel fields with MergeField in Word?

Hello everyone,

I have a specific form which needs to pull data from an Excel file and place the data in specific areas in Word. However, I fail to understand how to do the proper linking with MergeField, which I assume is the appropriate method.

Specifically, the Excel file has over 1000 data rows, each row has 2 numerical and 1 text cells that need to be linked to the form, so I assume with a successful MergeField I would have all the necessary forms automatically produced (1000 Word files for each Excel row) - or that is what I am understanding at least.

Can someone help me out achieve this?



Thank you in advance!
Reply With Quote
  #2  
Old 02-02-2016, 09:47 AM
Charles Kenyon Charles Kenyon is offline How to link Excel fields with MergeField in Word? Windows 8 How to link Excel fields with MergeField in Word? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Mail Merge
You want a name in the top row of your Excel sheet for each column being used. That gives you your mergefield names.

The Word end is handled under the Mailing tab.
You make your main document a mail merge document. Then you attach your data. Then in Word you can insert fields to the main document using the titles shown in the Excel sheet.
Reply With Quote
  #3  
Old 02-03-2016, 07:23 AM
Fabulist Fabulist is offline How to link Excel fields with MergeField in Word? Windows 10 How to link Excel fields with MergeField in Word? Office 2016
Advanced Beginner
How to link Excel fields with MergeField in Word?
 
Join Date: Sep 2015
Posts: 33
Fabulist is on a distinguished road
Default

Thank you for your response and please excuse my delay to reply. I was not even aware a wizard was available, for some reason, I always chose to ignore the option and do it via data insertions.

So I added the list with the proper headings and they do appear correctly; addresses, names, codes, phones and so on. I point the wizard where I want the data to be placed and I get { MERGEFIELD "Addresses" } for example. But during the preview, nothing happens, I still see { MERGEFIELD "Addresses" } instead of the address itself. This happens to all previews. Saving and reopening the document also changes nothing.

What am I missing?

EDIT: Something I did was blocking Word from doing its job, it is working now, thank you!

Can you tell me how to fix numerical values to appear as they are from the Excel table (only 2 decimals, not all)? MERGEFORMAT is working on this as far as I can tell.

Figured it out, thank you for your time.
Reply With Quote
  #4  
Old 02-03-2016, 02:32 PM
macropod's Avatar
macropod macropod is offline How to link Excel fields with MergeField in Word? Windows 7 64bit How to link Excel fields with MergeField in Word? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You have Word's field code display toggled on. Pressing Alt-F9 toggles it on/off.

As for the formatting issues, see the Mailmerge Tips and Tricks 'Sticky' threads at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mergefield with excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link Excel fields with MergeField in Word? Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
How to link Excel fields with MergeField in Word? MailMerge from Excel with Embedded MERGEFIELD McCap013 Mail Merge 1 05-13-2014 01:15 AM
How to link Excel fields with MergeField in Word? Word vs Excel (NEXTIF, SKIPIF mergefield) jerry00769 Mail Merge 3 04-30-2012 03:43 PM
How to link Excel fields with MergeField in Word? Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248 Joe Patrick Word VBA 2 01-30-2012 07:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft