Macro Help - Not even sure it can be done.

[malycom]

Is there a way to create a template for a word document to have certain
fields pre-populated with form fields and then create a macro to take the
necessity for a user to have to open Mail Merge wizzard and start locating
the data source etc?

Deeper.....

We run our in house software and we can press a 'Letter' button which
creates a .dbf file which is automatically saved in the root of the users C
drive. If they have created this .dbf file, it means they are going to send
a letter to the person who was on the form they were looking at before
clicking the 'Letter' button.

Now, just assuming that the only fields in the dbf file were
first name
last name
address
I would want the user to open there template document (not saved in the C
drive) which would already have the first name, last name and address form
fields in the correct place of the template.

This is when I would like the user to be able to press a form button or
whatever that will then automatically point the fileds to the corresponding
fields in the .dbf field so that our users do not have to try and use the
Mail Merge wizard. They WILL NOT use the Mail Merge wizard as they are
scared of computers.

I know this may be complex or even impossible, but if it can be done, you
will forever be deemed a hero. If it can't be done, other suggestions are
welcome.

Thanks in advance

Malcolm

 

[Stefan Blom]

You had better ask in a programming newsgroup such as
microsoft.public.word.vba.general for assistance with this.