I am in need of the same capability. I briefly looked at the VLookup
function and tried it, but got a Ref Error and instead came for some fast
help. Can you please send me that code as well. I would greatly appreciate
it.

Thanks!

"Bernie Deitrick" wrote:

bum,

I do that all the time. You can do it using VLOOKUP formulas and keying them
to a unique value from your table, then either manually selecting the value
from a list, or using a macro to cycle through all the appropriate values.
If you are interested, I can give you sample code.

HTH,
Bernie
MS Excel MVP


"bumrush_thesock" wrote in
message ...
I love how mail merge works in Word. I want to see a feature like that for
Excel. More specifically, I want to take data from Access and merge it
into
invoices that I make in Excel.