View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Mail Merge Data Question

1. Open the VB editor, type the following in the Immediate window

print activedocument.mailmerge.datasource.name
print activedocument.mailmerge.datasource.connectstring
print activedocument.mailmerge.datasource.querystring

(If you're using Word 2002 unfortunately some of those commands may fail).

Do the results give you any clues? If not, what are the results?

Peter Jamieson
"Tom Bean" wrote in message
...
I have a mail merge document that has never been linked to a data source
but shows data when Alt-F9 is pressed to hide the merge fields. The data
shown is from a data source, an Excel workbook, that was linked to another
mail merge document but the Excel workbook has been deleted.

My question is: Where is Word getting the data to merge into the
document?

Thanks,
Tom