merge function from one spreadsheet to another

[Pat]

I have a spreadsheet with names and addresses and another spreadsheet
that has to be sent to customers asking for various pieces of
information. I need to merge the address spreadsheet with the 2nd
spreadsheet in order to produce a copy for each customer. Is there a
function in Excel where I can do this? I've done merges with Word and
Excel many times but never using Excel as both the datasource and end
product. I'm using Excel 2003.
Thank you,
Pat

 

[Bernie Deitrick]

Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP

 

[Pat]

Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP






- Show quoted text -

Bernie, right now I just want printed copies.
Pat

 

[Bernie Deitrick]

Pat,

You can use a macro to print out the pages.

Let's say that you have names and addresses on sheet "Data Sheet" in column A to C, starting in Row
2, and a worksheet named "Info Request" that you want to print out once for each set of
name/address. The names are placed in cell B4, and the address in B5, and the city state zip in B6
of "Info Request"

This macro will create the print outs:

Sub PrintEmAllOut()
Dim myC As Range

With Worksheets("Data Sheet")
For Each myC In .Range(.Range("A2"), .Cells(Rows.Count, 1).End(xlUp))
Worksheets("Info Request").Range("B4").Value = myC.Value
Worksheets("Info Request").Range("B5").Value = myC(1, 2).Value
Worksheets("Info Request").Range("B6").Value = myC(1, 3).Value
Worksheets("Info Request").PrintOut
Next myC
End With

End Sub


HTH,
Bernie
MS Excel MVP

Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP






- Show quoted text -

Bernie, right now I just want printed copies.
Pat