[Sondra]

I have a letter that I want to merge with an records from an Access database.
I have no problem creating the fields for the mailmerge; however, I need to
be able to have the file stop at certain locations within the letter to enter
miscellaneous data. I have tried the Fillin field and also the Ask field,
but for some reason it isn't working.

Then I learned about User forms and wondered if I could mail merge with a
userfield.

So I have two questions:

1. Is it possible to create a mailmerge and have a Userform for the
miscellaneous fields?

2. Why would my ask fields not be working? The prompts pop up, but nothing
merges into the letter.

Any help would be great.

[Graham Mayor]

An ASK field merely prompts for information to be entered in a bookmark. To
insert the content of a bookmark, you need a REF field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sondra wrote:
I have a letter that I want to merge with an records from an Access
database. I have no problem creating the fields for the mailmerge;
however, I need to be able to have the file stop at certain locations
within the letter to enter miscellaneous data. I have tried the
Fillin field and also the Ask field, but for some reason it isn't
working.

Then I learned about User forms and wondered if I could mail merge
with a userfield.

So I have two questions:

1. Is it possible to create a mailmerge and have a Userform for the
miscellaneous fields?

2. Why would my ask fields not be working? The prompts pop up, but
nothing merges into the letter.

Any help would be great.

[Sondra]

Sorry can you expand on that a little more.

"Graham Mayor" wrote:

An ASK field merely prompts for information to be entered in a bookmark. To
insert the content of a bookmark, you need a REF field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sondra wrote:
I have a letter that I want to merge with an records from an Access
database. I have no problem creating the fields for the mailmerge;
however, I need to be able to have the file stop at certain locations
within the letter to enter miscellaneous data. I have tried the
Fillin field and also the Ask field, but for some reason it isn't
working.

Then I learned about User forms and wondered if I could mail merge
with a userfield.

So I have two questions:

1. Is it possible to create a mailmerge and have a Userform for the
miscellaneous fields?

2. Why would my ask fields not be working? The prompts pop up, but
nothing merges into the letter.

Any help would be great.

[albert]

One thing you can do to solve your problem is creating one or more columns on
your database which include the miscelaneous data. If for a given recipient
there is no miscelaneous data, then leave it empty for that record. That way
you won't have to make the merge stop at a given point.

[Doug Robbins - Word MVP]

You can use a fill-in field in the mailmerge main document for this purpose,
making use of one or more of the merge fields to display sufficient
information about the record that is being merged so that you will be able
to determine what information you need to enter. The field construction
would be as follows:

{ FILLIN { MERGEFIELD "fieldname" } }

You must use Ctrl + F9 to insert each pair of field delimiters { } and you
use Alt+F9 to toggle off their display.

When you execute this merge, a dialog box will appear with a prompt that
will include the data from the Merge field and a space into which you can
insert the miscellaneous data

--
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

"Sondra" wrote in message
...
Sorry can you expand on that a little more.

"Graham Mayor" wrote:

An ASK field merely prompts for information to be entered in a bookmark.
To
insert the content of a bookmark, you need a REF field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sondra wrote:
I have a letter that I want to merge with an records from an Access
database. I have no problem creating the fields for the mailmerge;
however, I need to be able to have the file stop at certain locations
within the letter to enter miscellaneous data. I have tried the
Fillin field and also the Ask field, but for some reason it isn't
working.

Then I learned about User forms and wondered if I could mail merge
with a userfield.

So I have two questions:

1. Is it possible to create a mailmerge and have a Userform for the
miscellaneous fields?

2. Why would my ask fields not be working? The prompts pop up, but
nothing merges into the letter.

Any help would be great.

[Graham Mayor]

If you respond to an ASK field the response is stored in a bookmark. That
bookmark content does not appear in the document by itself. To place the
content of a bookmark you would insert a REF field {REF Bookmarkname}.
It is possible to have that bookmark available to all records by using an \o
switch or prompt for a new one for each record - see word help under ASK
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Sondra wrote:
Sorry can you expand on that a little more.

"Graham Mayor" wrote:

An ASK field merely prompts for information to be entered in a
bookmark. To insert the content of a bookmark, you need a REF field.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sondra wrote:
I have a letter that I want to merge with an records from an Access
database. I have no problem creating the fields for the mailmerge;
however, I need to be able to have the file stop at certain
locations within the letter to enter miscellaneous data. I have
tried the Fillin field and also the Ask field, but for some reason
it isn't working.

Then I learned about User forms and wondered if I could mail merge
with a userfield.

So I have two questions:

1. Is it possible to create a mailmerge and have a Userform for the
miscellaneous fields?

2. Why would my ask fields not be working? The prompts pop up, but
nothing merges into the letter.

Any help would be great.