E
Eric
Hi,
I am currently developing a automated solution for a set
of letters that I have.
I have a third party database program that allows the
creation of letters by merging database fields to a
letter. This DOT file is always loaded from this 3rd party
DB. When loaded, it brings up the DOT file and
automatically assigns the values from the DB to the
mergefields on the letter.
The difficulty at the moment is that I have used the same
DOT file to create a VBA userform which does not exist
when the DOT file is loaded by the 3rd party DB. This is
because the coding does not exist on this new document,
instead on the original DOT.
Is there a way to keep the VBA coding and useform on the
same document once the letter has been loaded from the 3rd
party DB? I notice that the button on the new document
still exists after loading it from the DB, however, there
is no coding or userform behind it.
Your urgent help will be greatly appreciated.
Eric
Note: sorry for posting this in another sub-group as well,
as I don't know if I have posted it to the wrong area.
I am currently developing a automated solution for a set
of letters that I have.
I have a third party database program that allows the
creation of letters by merging database fields to a
letter. This DOT file is always loaded from this 3rd party
DB. When loaded, it brings up the DOT file and
automatically assigns the values from the DB to the
mergefields on the letter.
The difficulty at the moment is that I have used the same
DOT file to create a VBA userform which does not exist
when the DOT file is loaded by the 3rd party DB. This is
because the coding does not exist on this new document,
instead on the original DOT.
Is there a way to keep the VBA coding and useform on the
same document once the letter has been loaded from the 3rd
party DB? I notice that the button on the new document
still exists after loading it from the DB, however, there
is no coding or userform behind it.
Your urgent help will be greatly appreciated.
Eric
Note: sorry for posting this in another sub-group as well,
as I don't know if I have posted it to the wrong area.