There should be a mail merge feature between excel and access.

B

bumrush_thesock

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

Bernie Deitrick

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
 
V

Vira-SJH

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!
 
Top