I am automating a mail merge type process for a user.

EXPLANATION MY PROCESS THOUGHTS
User is in excel on data sheet. They select the address to use. They click a button to run this macro that does the following...

Active Selection (I will call this "Cell 1")
Copy Selection
Paste into another sheet (I will call this "A1", it is the master cell of the data)
Alt+Enter A1 (preps the format for next piece of data being copied in)
offset cell 1 by (0,2) for next piece of data
copy it
paste in A1

Repeat untill address is complete.

Then copy A1 to clipboard
Open Avery 5160 word file I have (I know how to do this)

User will then Paste their address

for added effect because they can add several addresses into the document I would like to then have the code know after the paste has been done, ask the user if they want to print yet.
No= save and close word doc
Yes= print (they can close it manually at that point)


Anyone throw me something I can run with? Did I explain well/any questions? Thanks for any help, I know its a lot to grasp!