merge excel data to MS word

[wbaid]

I am doing a thank letter for donations I received I have a letter written and I have Excel spread sheet with the names of the donors and amounts and address now what I want to do is take that information from excel and put in word instead of copy and pasting them one by one. Is there any way I can merge data from Excel file into Existing World document template automatically.

Any suggestion / help appreciated.

 

[VoG]

Take a look at Mail Merge in Word. you can specify a worksheet as the data source.

 

[wbaid]

I tried doing that but I am not sure how it works, do you have define a character so it picks from there? Please advise

 

[kidwispa]

I am doing a thank letter for donations I received I have a letter written and I have Excel spread sheet with the names of the donors and amounts and address now what I want to do is take that information from excel and put in word instead of copy and pasting them one by one. Is there any way I can merge data from Excel file into Existing World document template automatically.

Any suggestion / help appreciated.

Yes you can you mail merge in Microsoft word. I'm not sure what version of MS Office you are using but check this out for information:

http://office.microsoft.com/en-us/w...-for-mass-mailings-RZ010277841.aspx?section=2

Hope this helps

 

[wbaid]

Thanks all.