I put together several document submittals per day, and for the coversheet I manually copy/paste from an Excel table into Word for the document list. Also, each coversheet has a header with the submittal info as such:
Project Name Project Location Project No. Submittal No. Date
Based on these data, I could easily query a spreadsheet and automate the interface... if only I knew how. I remember OpenOffice was good at doing this sort of thing, but that was months ago when I tried it and I cannot find the same functionality in Word. What am I missing?
P.S. I have Access 2010, which may be better for this sort of thing, but I'm not comfortable using it as I am with Excel/Word. Would it be a better idea overall though?