I have an application that will be distributed remotely. In the
Access application I am opening Word documents and mail merging. The
Word documents are linked to a tmpLetter table. In my code I write
the records to be merged into that table. The Word documents are
using a system dsn (ODBC) to connect to the data source. In my code I
simply open the Word documents after writing to the table do a mail
merge and print.
It runs pretty quick and I like it but alas my problem in creating a
setup program using Access I cannot create registry entries. The way
I am doing it won't work unless I create the system dsn in code or
have the user do it. I don't know if I want to do that.
I am also offering the user the option of exporting the records into
Excel so I pretty much have to use a temp table to do that. So even
if I were to do it a different way like with Word bookmarks I would
still need this table.
Okay so before I waste a lot of time converting my code to using
bookmarks I am wondering what is good and more importantly what is bad
about using them.
TIA
Tom