#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#4
|
|||
|
|||
solution
will not cross post again unless it is needed. if there is a need will so reference in both places.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
add mergefields to exsting word 2013 | jassie | Word | 2 | 02-09-2017 05:53 PM |
Mail Merge - how to pad mergefields | Trailblazer | Mail Merge | 1 | 10-28-2016 03:30 PM |
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet | Labyrinth | Word | 7 | 07-19-2016 01:35 PM |
Outlook 2013 opens Word attachments in Word 2013 despite Word 2010 being preferred version | Charles Kenyon | Outlook | 2 | 01-26-2016 03:17 PM |
Export data from C# winForms treeView to MS-Word MergeFields | nisim651 | Mail Merge | 8 | 04-18-2014 04:17 AM |