Merging Excel and Word

[dlish]

I have a spread sheet in Excel with names and addresses ect. I am needing to send out a form letter in word is there a way for excel and word to talk to eachother- fill in the blank Dear _____ and print out address labels?

Thanks for any pointers

 

[kidwispa]

I have a spread sheet in Excel with names and addresses ect. I am needing to send out a form letter in word is there a way for excel and word to talk to eachother- fill in the blank Dear _____ and print out address labels?

Thanks for any pointers

You can use Mail Merge to do this...

have a look at this link as it might help...

http://www.internet4classrooms.com/msword_formletter.htm

 

[bulevardi]

As in a text like "Dear _____" I don't have an example ready...
But I can help with mailing labels ...
Just have a demo ready for this, in Excel 2010. Not sure if it'll work in older versions.
http://bulevardi.be/?content=scripting&example=exvb3