View Single Post
 
Old 05-29-2009, 02:48 PM
webarnes webarnes is offline Windows XP Office 2007
Novice
 
Join Date: May 2009
Posts: 2
webarnes is on a distinguished road
Default

Ok.
I may have half of a solution. I need a few days to work it out.
I utilized my original excel table file and the word mail merge feature.
In order to work around mail merge deficiencies I created a new tab in excel for the mail merge data.
I created a header row and titled each COLUMN.
Then I created a row to hold the information from the form input cells. Essentially changing the user input from a column format to row format.
This solved the problem that mail merge will not allow you to select an excel column and change the row for each new input into the word document.
Mail merge will allow you to check a specific excel row. Once selected you can input any column you want into the page.
Now I can maintain the excel form in a proper format for ease of use. Grab the data from one tab to another, formatting it into a row format.
Then use mail merge to grab the data from the excel file.
I put the excel file in the root folder and tell all the word documents that is the data source location.
When I edit the file the documents update.

The big pitfall I am trying to work around is the ability to save the folder of files as a new job name in a new folder location.
The data bind is looking for an exact location. Ie C:\Documents\folder\file.ext
I cannot figure out how to reference it as a local file.
What I want to do is tell it to reference the file from the containing folder ..\new folder\file.ext or ..\file.ext.
Any suggestions would be appreciated.
Thanks,
William
Reply With Quote