Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Updating Links from Excel to Word
I have a form letter within Word, which I send out to multiple tenants of
mine. Everything written is the same except for the tenants name, address, & rental due. This data is contained within one Excel sheet. Also, the rental amounts change every now and then (which then needs to be updated in Word). Is there a way I can have certain portions within the Word document "linked" (& preferably automatically updated) to certain cells within an Excel sheet? In the past, I have done the standard "Copy" & "Paste", but I have to keep re-doing it every time I update the Excel data. Is there an easier way? Thanks! |
#2
|
|||
|
|||
A mail merge is the best solution for your problem. Create a mail merge and
link it to your Microsoft Excel® worksheet. Once you update the Microsoft Excel® data, you can tell Microsoft Word® to get the most recent data from your Microsoft Excel® data source and complete the mail merge. Before I provide instructions, which version of Microsoft Word® and Microsoft Excel® are you using? Please reply to this post and I will guide you from there. Kimberly Pittmon "mace" wrote: I have a form letter within Word, which I send out to multiple tenants of mine. Everything written is the same except for the tenants name, address, & rental due. This data is contained within one Excel sheet. Also, the rental amounts change every now and then (which then needs to be updated in Word). Is there a way I can have certain portions within the Word document "linked" (& preferably automatically updated) to certain cells within an Excel sheet? In the past, I have done the standard "Copy" & "Paste", but I have to keep re-doing it every time I update the Excel data. Is there an easier way? Thanks! |
#3
|
|||
|
|||
Thanks for your help.
I use the XP version for both Word and Excel. Mason "KP, Microsoft Master Instructor" wrote: A mail merge is the best solution for your problem. Create a mail merge and link it to your Microsoft Excel® worksheet. Once you update the Microsoft Excel® data, you can tell Microsoft Word® to get the most recent data from your Microsoft Excel® data source and complete the mail merge. Before I provide instructions, which version of Microsoft Word® and Microsoft Excel® are you using? Please reply to this post and I will guide you from there. Kimberly Pittmon "mace" wrote: I have a form letter within Word, which I send out to multiple tenants of mine. Everything written is the same except for the tenants name, address, & rental due. This data is contained within one Excel sheet. Also, the rental amounts change every now and then (which then needs to be updated in Word). Is there a way I can have certain portions within the Word document "linked" (& preferably automatically updated) to certain cells within an Excel sheet? In the past, I have done the standard "Copy" & "Paste", but I have to keep re-doing it every time I update the Excel data. Is there an easier way? Thanks! |
#4
|
|||
|
|||
Hi ?B?bWFjZQ==?=,
I use the XP version for both Word and Excel. Apparently, Kimberly isn't following up on this. I believe you'll find tutorial information on using mail merge at word.mvps.org If you have any further questions, I recommend asking them in the word.mailmerge.fields newsgroup, where you should get a reasonably timely response. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#5
|
|||
|
|||
Thank you for following up to my question. Very kind of you.
Mason "Cindy M -WordMVP-" wrote: Hi ?B?bWFjZQ==?=, I use the XP version for both Word and Excel. Apparently, Kimberly isn't following up on this. I believe you'll find tutorial information on using mail merge at word.mvps.org If you have any further questions, I recommend asking them in the word.mailmerge.fields newsgroup, where you should get a reasonably timely response. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Editing links to excel in form-protected word document | Microsoft Word Help | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |