Using office 2003:
No command line parameters to do this.
One option could be to filter all records but the one you want to merge.
Link the Excel data source to the main merge document using DDE (not the
default 2003 OLE DB). Set up a filter in the main merge document to
merge only records where a particular field that you know always
contains data are "Not Blank". (DDE sees records that are filtered out,
but no field data; so only the visible records will be merged.)
The other option would be to use Automation (VBA) to open the main merge
document and set the QueryString property of the documents'
MailMerge.DataSource object. This would be a valid SQL SELECT statement
such as: "SELECT * FROM 'completepath.Excel.xls' WHERE myFieldName=1234"
I have an Excel spreadsheet that is the source data for several
mailmerge documents. Within the spreadsheet, I have links to each of
these mailmerge documents. I would like to customize these links to
make word open the document AND select a designated record number for
the mailmerge. (I'll have a link to the word document for each row of
data, and by clicking on the right link, I'll pull up that same row's
data on the merged Word document.
Another way of asking this is this: Are there command line parameters
or VBScript commands that will allow a variable to be inserted into a
mailmerge template's record number?
I suspect I may need to alter the word document (change the record
number) before it is opened each time.
Switching to Access instead of Excel is not an option here.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)