Insert Merge Field |
|
The last retrieved data set (result from executing a select statement) remains available in Excel. Using the insert
merge field menu you can create Excel formulas that retrieve the current value for one of the columns in the data
set. In the menu there will be an item for each column in the data set as well as a button to create a small table
with a formula for all columns.
An example of the merge field formula:
=sqlxl.xla!MergeField("empno")
You need to use the merge fields in your own spreadsheet template when doing mail merges with your data set.
See also: