#1
|
|||
|
|||
Help Plz! Link Excel data to Word document
I have an Excel spreadsheet that users use to enter data into. They then copy and paste this data into a Word template that then gets mailed. I want to be able to remove the need to copy and paste. Therefore I am looking for a way to get Word to check and see if certain cells are not blank and then take the cell information from another cell. For example. Column A has account #, Column B has Name, Column C is either blank or has an "X" in it. I would like to Word doc to check the cells that contain X's and if an X is there, copy the information from Column A and B. There is multiple rows so it would need ot continue on until it doesn't see any more data in column A. Is this something that is possible and if so, what would be the most efficient way to accomplish this?
Thanks, Cory |
#2
|
||||
|
||||
Have you considered mailmerge?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
excel 2010 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I link a Word document to another Word document with automatic update? | KristinLeigh | Word | 14 | 01-05-2014 02:18 PM |
How to dynamically link imbedded Excel chart with source data from Word | TBoz | Excel | 1 | 07-06-2012 05:53 PM |
How to link userform to another word document | SaneMan | Word VBA | 5 | 10-14-2011 05:12 AM |
Link data from embedded excel sheet | rwbarrett | Word | 1 | 05-27-2011 02:05 AM |
Excel 07-Access 03 Data Link Issue | ddw23 | Excel | 0 | 08-20-2010 09:05 AM |