I've got about 150 addresses/names that I am sending a letter to (same letter, just different receipients) in Excel. Is there anyway to automatically transfer the information in Excel to the letter (in word), so that I don't have to type in all of these addresses?

[Edited on June 1, 2008 at 7:29 PM. Reason : in office 2007*]

6/1/2008 7:26:27 PM

nvm, i think i got it now

6/1/2008 7:32:03 PM

copy/paste

6/1/2008 8:24:36 PM

mail merge i believe

6/1/2008 8:34:10 PM

^^

^yeh, that's it. too bad it won't do envelopes from excel too

6/1/2008 8:44:44 PM

you should be able to tell Word to use the excel file as its data source

6/1/2008 8:45:34 PM

^well the "envelopes" function in word wanted me to select the address for each letter, so I just created a new word file and set it up for envelopes, and then added the addresses the same way as the letters

6/1/2008 9:07:47 PM