Mustang3
10-07-2008, 03:45 PM
This is my first experience with this forum (or any forum for that matter). If my question has been answered already, maybe you could refer me to that thread.
I found an article by Ken Puls at vbaexpress kb, "..../kb/getarticle.php?kb_id=381" (I can't post links yet). It was called "Push Excel Named Range Values to Bookmarks in Word." This is very close to what I am hoping to do.
I would like to treat the excel spreadsheet as a database with each row being a separate record. For example, a single worksheet with many rows of name, address, phone number, etc. cells as fields. Then I would like to be able to "select" a particular row and have those cell values for that row pushed into a word template such as a form letter. - I do not want to push the information from the non-selected rows.
Can the code in the above article be tweaked to do that? Or, has someone already written a macro that I might be able to use? Or, is this not really doable?
Thanks in advance....
I found an article by Ken Puls at vbaexpress kb, "..../kb/getarticle.php?kb_id=381" (I can't post links yet). It was called "Push Excel Named Range Values to Bookmarks in Word." This is very close to what I am hoping to do.
I would like to treat the excel spreadsheet as a database with each row being a separate record. For example, a single worksheet with many rows of name, address, phone number, etc. cells as fields. Then I would like to be able to "select" a particular row and have those cell values for that row pushed into a word template such as a form letter. - I do not want to push the information from the non-selected rows.
Can the code in the above article be tweaked to do that? Or, has someone already written a macro that I might be able to use? Or, is this not really doable?
Thanks in advance....