Quote:
Originally Posted by Charles Kenyon
Why are you using links like this rather than mail merge?
|
Perhaps because there's a separate workbook for each bid and mailmerges only work with a single data source.
Although a mailmerge could be used to output a single record, you'd still have to change the data source for each workbook and, compared to links, the resulting Word documents are static. Consequently, you'd have to work with the mailmerge preview until the editing's finished; otherwise you'd be unable to auto-update the document to reflect ongoing changes in the Excel data.