Microsoft Office Forums Merge Field Not Populating

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2016, 08:03 PM
JennEx JennEx is offline Merge Field Not Populating Windows XP Merge Field Not Populating Office 2013
Competent Performer
Merge Field Not Populating
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default Merge Field Not Populating

I have an interesting problem that I have no idea how to overcome it.



I have two cells of a table, that despite appropriate mail merge field names being in them, during preview and actual merge document creation, the fields remain blank.

Mergefield view....



Preview...



The cells are formatted for black text. The other mailmerge fields in a table in the header populate without problem.

Can anyone suggest what might be going on here?
Reply With Quote
  #2  
Old 03-29-2016, 09:25 PM
macropod's Avatar
macropod macropod is offline Merge Field Not Populating Windows 7 64bit Merge Field Not Populating Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Are the problem mergefields in a table in a textbox in the page header? If so, try using them without the textbox (e.g. in just a floating table).
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-30-2016, 10:21 AM
JennEx JennEx is offline Merge Field Not Populating Windows XP Merge Field Not Populating Office 2013
Competent Performer
Merge Field Not Populating
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

Hi Paul, thank you for your reply ...

I believe this is strictly a table, much like the field placement to the right of the problem cells. Since I really don't know anything about textboxes as they relate to Word, I would doubt I would have used any in this document (unless by accident).

The interesting thing, is this problems does not exist on my school computer. Both my home and school computers are running the same version of Word and Excel, but between the two, are different results.

Ie - at home, I needed to change the Data Source to MS Excel Worksheets via DDE (*.xls) to get Excel's decimal time to format as h:mm AM/PM, but not on my school computer. Hopefully there is no no cross functionality issues.
Reply With Quote
  #4  
Old 03-30-2016, 02:06 PM
macropod's Avatar
macropod macropod is offline Merge Field Not Populating Windows 7 64bit Merge Field Not Populating Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

If you could attach a copy of your mailmerge main document to a post (delete anything sensitive), I could investigate the issue further. You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-30-2016, 04:05 PM
JennEx JennEx is offline Merge Field Not Populating Windows XP Merge Field Not Populating Office 2013
Competent Performer
Merge Field Not Populating
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

Thank you Paul ...
Now that I am home, those two fields don't populate (or show up with merge data)
Attached Files
File Type: docx DR15v1b.docx (34.8 KB, 8 views)
Reply With Quote
  #6  
Old 03-30-2016, 04:26 PM
macropod's Avatar
macropod macropod is offline Merge Field Not Populating Windows 7 64bit Merge Field Not Populating Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The fields, etc. look OK. Are you sure there are data in the 'DATE' field in the data source for the DR type?

On a side issue, I note that you're using CREATEDATE fields just below the problem DATE MERGEFIELDS. Be aware that the date inserted by these will be the date the mailmerge main document was created, not the date the merge is executed. To output the date & time the merge is executed (as text), you could use a compound field coded as:
{QUOTE{DATE \@ "d-MMM-yy h:mm:ss am/pm"}}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 03-30-2016, 06:23 PM
JennEx JennEx is offline Merge Field Not Populating Windows XP Merge Field Not Populating Office 2013
Competent Performer
Merge Field Not Populating
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

Quote:
Are you sure there are data in the 'DATE' field in the data source for the DR type?
Yes ... as I mentioned, oddly, i works on my school computer. Same report, same data source. The only difference, is at home I have to use DDE, whereas at school I seem to not have to.

I'm not all that familiar yet with mail merge and Excel data integration so it's a huge mystery to me!

Let me say, I do appreciate your support. Thanks Paul!
Reply With Quote
  #8  
Old 03-30-2016, 08:08 PM
macropod's Avatar
macropod macropod is offline Merge Field Not Populating Windows 7 64bit Merge Field Not Populating Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

OK, if it's working with DDE but not otherwise, that suggests you might have mixed data types in the DATE field, meaning the data aren't being interpreted correctly.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 03-31-2016, 06:30 PM
JennEx JennEx is offline Merge Field Not Populating Windows XP Merge Field Not Populating Office 2013
Competent Performer
Merge Field Not Populating
 
Join Date: May 2010
Posts: 158
JennEx is on a distinguished road
Default

Thanks again ... I will look back into the data and see if there might be some inconsistent data.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Field Not Populating Excel List Box not populating worksheet field upon submit Shane.Hutchison Excel Programming 1 10-22-2015 12:24 PM
Mail Merge Field Not Populating JennEx Mail Merge 3 05-10-2015 09:30 PM
Merge Field Not Populating How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
Merge Field Not Populating Populating ComboBox or Drop Down list with contents of a text field Billy_McSkintos Word VBA 1 09-13-2011 05:50 AM


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


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