I have a word template (.dot) that contains bookmarks that get replaced with
data from our SQL database into a form letter
..
Every time I have many employee numbers listed, one page will open for each
employee. So if I select 20 employee numbers. 20 separate pages will be
opened on my computer screen. I want to merge all the employee numbers into
one word document so that I have a 20 page word document rather than 20
separate word pages opened on my PC.



Can someone please help? Is this even possible?

If you were to use mailmerge and merge to a new document, that is what you
would get.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Jeanne Moos" wrote in message
...
I have a word template (.dot) that contains bookmarks that get replaced
with
data from our SQL database into a form letter
.
Every time I have many employee numbers listed, one page will open for
each
employee. So if I select 20 employee numbers. 20 separate pages will be
opened on my computer screen. I want to merge all the employee numbers
into
one word document so that I have a 20 page word document rather than 20
separate word pages opened on my PC.



Can someone please help? Is this even possible?

True that is what merge does. See the SQL database is linked to word. So when
the user selects the form. The form displays and prints. We only have access
to the simple form letter merges. Basically I'm trying to change the behavior
of the form
letter. I was hoping to find some script that would 1. prevent the files
from opening up on my desktop 2. merge it into one word document.

Can you help?

"Doug Robbins" wrote:

If you were to use mailmerge and merge to a new document, that is what you
would get.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Jeanne Moos" wrote in message
...
I have a word template (.dot) that contains bookmarks that get replaced
with
data from our SQL database into a form letter
.
Every time I have many employee numbers listed, one page will open for
each
employee. So if I select 20 employee numbers. 20 separate pages will be
opened on my computer screen. I want to merge all the employee numbers
into
one word document so that I have a 20 page word document rather than 20
separate word pages opened on my PC.



Can someone please help? Is this even possible?