B
bml337 via AccessMonster.com
I want to develop a db that will will manage all my client documents.
Currently i have standard documents that i run a "find and replace on"... and
save as a new document with new client info.
I want access to automate this process by using "forms" to input the data.
Then, i want to run a report or macro that will pull client specific data
from a table, then populate my documents accordingly.
I am currently managing 100+ word documents (some 1 page long and other 300+
long). I am not sure where to start... should i leave them in word or should
i make them reports... am i missing other options?
I tried putting a 5 page document into a report, but it turned it into an
image. Then i tried to copy the text, but would not let me copy more then
2000 characters.
I then created a mail merge with one of the documents... where it pulled the
data from access. This worked, but I had to run this from the word document..
i am assuming i can run a macro from access, to run this process.
for example create so an so document for xyz client... then word document
pops up with client info populated.
thanks in advance
b
Currently i have standard documents that i run a "find and replace on"... and
save as a new document with new client info.
I want access to automate this process by using "forms" to input the data.
Then, i want to run a report or macro that will pull client specific data
from a table, then populate my documents accordingly.
I am currently managing 100+ word documents (some 1 page long and other 300+
long). I am not sure where to start... should i leave them in word or should
i make them reports... am i missing other options?
I tried putting a 5 page document into a report, but it turned it into an
image. Then i tried to copy the text, but would not let me copy more then
2000 characters.
I then created a mail merge with one of the documents... where it pulled the
data from access. This worked, but I had to run this from the word document..
i am assuming i can run a macro from access, to run this process.
for example create so an so document for xyz client... then word document
pops up with client info populated.
thanks in advance
b