Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mace
 
Posts: n/a
Default 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!
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Editing links to excel in form-protected word document Laura Microsoft Word Help 13 December 16th 04 12:57 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 03:42 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"