View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Tonne Tonne is offline
external usenet poster
 
Posts: 2
Default 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