Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge: reopening saved document prompts for SQL command twice
I am trying to merge a csv file:
Name;Address;Zipcode;City My name;Where I live;DK-0000;Nearby With a template containg bookmarks for Name, Address, ... Everything works except for the two prompts for executing SQL commands when the document is reopened. First a prompt for the real csv file and then a prompt for a temporary csv file. If I accept both the merge is repeatable. If i print the query from VBA (ctrl-G print activedocument.mailmerge.datasource.querystring) the result is a query on the temporary file. Here is the code (using 'generic' COM classes for everything): COMappl = new COM(Word.Application); COMdocuments = COMappl.documents(); COMdocument = COMdocuments.open(template); // variable holding the template file COMdocument.saveas(filename); // variable holding the saved doc COMappl.visible(true); COMmailmerge = COMdocument.mailmerge(); COMmailmerge.OpenDataSource(fileNameData,0,0,0,1); // variable holding the datafile (csv) COMmailmergefields = COMmailmerge.fields(); COMbookmarks = COMdocument.bookmarks(); COMbookmark = coMbookmarks.item('Name'); COMrange = coMbookmark.range(); COMmailmergefields.Add(COMrange,'Name'); // insert just one merge field COMmailmerge.Execute(); COMappl.Activate(); COMdocument.save(); Any ideas? -- Tonne |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reopening document with cursor at same location as when saved?word 2007. | Microsoft Word Help | |||
reopening document with cursor at same location as when saved? word2007. | Microsoft Word Help | |||
mail merge without prompts | Mailmerge | |||
Add-ins tab disappears after reopening a previously saved docx doc | Microsoft Word Help | |||
Mail Merge - Parameter prompts twice... | Mailmerge |