View Single Post
  #1   Report Post  
jaewon223
 
Posts: n/a
Default How do I do an excel merge like a word mailmerge with another exc.

I have two excel files, one is a data excel file and the other is what i want
to merge the data file into. I want to be able to merge like I do for word
document where there is a mail merge and it creates a separate page for each
merge that it completes. Is this possible?

e.g.

<<First Name <<Last Name
<<Address1
<<Address2
<<City, <<State <<Zip


If I want to be able to merge an excel sheet that contains this data into a
different excel sheet that looks for each value AND continues to merge the
rest of the document how would I go about doing that?