Saturday, November 19, 2011

Transfering multiple cell info to a word document?

I have a customer list with over a 1000 customers. Row A has name, B has address, C zip code, D phone number, etc. I also have a word document that has a heading for Name, Address, and Phone, its kind of like a personal survey but for customers and we just want an automated process rather than hand writing everything. Is there a way to take, like a macro, to take the info from the spread sheet and put it onto a workd document and have it print each one?

Transfering multiple cell info to a word document?
Word 2003


When in word go to Tools then Letters and mailings then Mail merge and then follow wizard
Reply:You can use letter merge in Ms Word. In Word 2007 it in Mailing %26gt; Select Recipients %26gt; Use Exciting list
Reply:Create the macro by copying and pasting the information from Excel into Word for the first line of data. Then open the macro information to confirm how the system has written the macro, then amend it to continue to run the macro for each line of your Excel spreadsheet.


No comments:

Post a Comment