Microsoft Office Forums add mergefields to exsting word 2013

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2017, 04:13 PM
jassie jassie is offline add mergefields to exsting word 2013 Windows 7 64bit add mergefields to exsting word 2013 Office 2007
Novice
add mergefields to exsting word 2013
 
Join Date: Feb 2012
Posts: 18
jassie is on a distinguished road
Default add mergefields to exsting word 2013

In an existing Word 2013, I am trying to add mergefields to the existing document and actually see data from the database in the new mergefields that I am using. However somehow I am doing something incorrectly since I am not accomplishing my goal.
When the document opens, the following query appears, Select * from 'viewMailing' and I hit the 'yes' button. Then a selection for a datasource is selected and I pick +newSQLServerConnection.odc, I click open and only 1 record is selected with some kind of data.
Now on mailings tab, I do the following:
1. place my cursor where I want one new column from the database to be place on the word 2013 document,


2. I select 'Insert Merge Fields',
3. I highlight the database field I want and click the insert button.
4. I hit the peview results button and all the data from the database record is gone,
5. I then hit the preview results button again and no data is displayed. I see all the original merge fields plus the new merge field that I just inserted.
6. I hit the merge button again all the data from the database is gone.
Notes: When the Select * from 'viewMailing' is executed, I know there is nothing that is actually selected. This is something I am going to work on in the query. I do not know exactly where the one row is coming from unless it was obtained from the original odbc connection.
Thus can you tell me how to add mergefields to the existing document and actually see data from the database in the new mergefields that I am using?
Reply With Quote
  #2  
Old 02-10-2017, 05:30 AM
macropod's Avatar
macropod macropod is offline add mergefields to exsting word 2013 Windows 7 64bit add mergefields to exsting word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
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

When you complete the merge, the resulting new document contains no mergefields. This is by design. The mergefields will still be in your mailmerge main document, however.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-10-2017, 05:32 AM
macropod's Avatar
macropod macropod is offline add mergefields to exsting word 2013 Windows 7 64bit add mergefields to exsting word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
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

Cross-posted at: https://www.office-forums.com/thread...-2013.2349853/
and:
https://social.technet.microsoft.com...013?forum=word
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 02-10-2017, 10:59 AM
jassie jassie is offline add mergefields to exsting word 2013 Windows 7 64bit add mergefields to exsting word 2013 Office 2007
Novice
add mergefields to exsting word 2013
 
Join Date: Feb 2012
Posts: 18
jassie is on a distinguished road
Default solution

will not cross post again unless it is needed. if there is a need will so reference in both places.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
add mergefields to exsting word 2013 add mergefields to exsting word 2013 jassie Word 2 02-09-2017 05:53 PM
add mergefields to exsting word 2013 Mail Merge - how to pad mergefields Trailblazer Mail Merge 1 10-28-2016 03:30 PM
add mergefields to exsting word 2013 Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet Labyrinth Word 7 07-19-2016 01:35 PM
add mergefields to exsting word 2013 Outlook 2013 opens Word attachments in Word 2013 despite Word 2010 being preferred version Charles Kenyon Outlook 2 01-26-2016 03:17 PM
add mergefields to exsting word 2013 Export data from C# winForms treeView to MS-Word MergeFields nisim651 Mail Merge 8 04-18-2014 04:17 AM


All times are GMT -7. The time now is 10:23 PM.


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