#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thank you Paul ...
Now that I am home, those two fields don't populate (or show up with merge data) |
#6
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
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! |
#8
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Thanks again ... I will look back into the data and see if there might be some inconsistent data.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |
Populating ComboBox or Drop Down list with contents of a text field | Billy_McSkintos | Word VBA | 1 | 09-13-2011 05:50 AM |