[[email protected]]

A follow up question:

I've decided the filtered DDE solution is the easiest for me. I now
have a column used to flag items to include in the mailmerge, and I put
a "1" in the selected row of this column before launching my mailmerge.
It works perfectly. Thanks! That problem had me stumped for a long
time.

Now I'd like to automate it further with a macro. I'll also be
scouring an excel programming group, but wondered if anyone here might
have some insight.

I want a macro that notices which row is active, places a "1" in the
Mailmerge column of that row, launches a hyperlink to the mailmerge
document, then replaces the "1" with null. The end result will allow
the user to select a row, click the macro titled "Mailmerge", and the
word document pops up with that row's data.

any suggestions?


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.)

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.