#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
|
|||
|
|||
|
#3
|
|||
|
|||
Save your document after you add the fields.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Which ODF/ .odt version is word 2010, 2013 preview & eventually 2013 full using? | semiotically | Word | 8 | 11-08-2012 05:44 PM |