Need Helping Creating Mailmerge File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sondra - 10 Aug 2006 05:08 GMT

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.

Reply to this Message

Graham Mayor - 10 Aug 2006 06:31 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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;
[quoted text clipped - 15 lines]
>
> Any help would be great.

Reply to this Message

Sondra - 10 Aug 2006 16:19 GMT

Sorry can you expand on that a little more.

> 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.
[quoted text clipped - 18 lines]
> >
> > Any help would be great.

Reply to this Message

Albert - 10 Aug 2006 16:36 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 10 Aug 2006 18:44 GMT

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

Signature

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

> Sorry can you expand on that a little more.
>
[quoted text clipped - 21 lines]
>> >
>> > Any help would be great.

Reply to this Message

Graham Mayor - 11 Aug 2006 06:30 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Sorry can you expand on that a little more.
>
[quoted text clipped - 28 lines]
>>>
>>> Any help would be great.

Reply to this Message