Re: mail merge

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I apologize, yes the data source is an database and the mail merge type is a
word is a directory. The source of the (body) or unique text will be
inputted by the user. Using the below example:

Name: auto-populate Address: auto-populate (heading)
Comments: unique text that will change for every name (body)

The Name and Address fields would be auto-populated from the access
database. The Comments would be text that the user would input. Does that
make sense? Thanks.


"Doug Robbins - Word MVP" wrote:

I guess when you said that the main document is an access database, you
meant that the data source is and access database. the mail merge main
document will be a Word document, at it can be one of a number of types -
Letter, Envelope, Label, Directory, etc. It may not be relevant to your
actual problem, but I gather that you are using a Directory type mail merge
main document.

The question really is, what is the source of the Comment? That is, the
unique text that will change for every name (body)?


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

"cmccabe" <cmccabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E3CAACAE-0757-47C4-BE59-F5E1605ED075@xxxxxxxxxxxxxxxx
The main document is an access database. I have setup the merge through a
directory. Basically, I enter information such as name, age, address, and
gender in the database. Then have a mail merge setup in which name and
address auto-populate two fields in the header of the document.
Underneath
that there is space for comments that will be unique. As of now I can not
seem to get unique text in the merged document. Rather the same text
appears
on every record. The design looks like this:

Name: auto-populate Address: auto-populate (heading)

Comments: unique text that will change for every name (body)

Thanks.

"Doug Robbins - Word MVP" wrote:

What type of mail merge main document are you using?

If it's a Directory type, and by header you mean header as in the header
or
footer of a document, merge fields in such a header of a such a document
do
not work. However, if the "header" is in the main body of the
document, a
merge field in that "header" should work correctly, though the "header"
text
will be repeated for each record in the data source.

Tell us some more about the mail merge main document, or send a copy of
it
to me to look at if you want.

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

"cmccabe" <cmccabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F705071C-0F46-4CEC-B9B1-8BAD0D9972FB@xxxxxxxxxxxxxxxx
Hello,

I have an access 2003 database that populates a header in a word 2003
report. Under the header the text will be unique, however when I go to
each
record in the mail merge the same text appears and it can not be
deleted
without erasing all the records. How can I make the text unique to each
record? Thanks.







.



Relevant Pages

  • Re: mail merge
    ... would be better to have a field in the database into which the appropriate ... Doug Robbins - Word MVP ... and by header you mean header as in the ... will be repeated for each record in the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: mail merge
    ... Doug Robbins - Word MVP ... meant that the data source is and access database. ... and by header you mean header as in the ... will be repeated for each record in the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... "Peter Jamieson" wrote: ... within the database name text box. ... let's step through the basic approach needed to make the connection ... start the process of connecting to a data source ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Import external data - web query
    ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... I can't create a new data source in Microsoft Query. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)