View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default MailMerge - Word 2000

but I'm clearly doing
something wrong.


Not necessarily...

When you open your mail merge main document (and are connected to the data
source), do you see any of the paragraphs?

If you show the fields in preview mode (where you can see the results - use
Alt-F9 and Tools|Customize to enable the mailmerge toolbar and click the
button if necessary) do you see those paragraphs included? If not, if
you select the whole document using ctrl-A, then update all the fields using
F9, do you see them? If not, can you use Alt-F9 to expose the underlying
field codes, then select the first IF field, right-click and select Toggle
Field Codes to show the result of the IF field. What do you see? (You should
see Para1.) If you don't, temporarily replace the IF field with the text
Para1, try updating the INCLUDETEXT field again and show its result. If you
don't see the paragraph bookmarked Para1 included, then my guess is that
there is something wrong with the bookmarks.

Unfortunately, you may also have to follow this KB article:

http://support.microsoft.com/kb/330554

Peter Jamieson

"sandra via OfficeKB.com" u5657@uwe wrote in message
news:60aefdb6bb03a@uwe...
Hi Peter

I'm really sorry to keep coming back with this but I'm clearly doing
something wrong.

I've inserted all the paragraphs into a document, highlighted each
paragraph
and bookmarked. I've highlighted the paragraph mark at the top of the
document and called it "Para0". I now have 9 bookmarks (just testing at
the
moment). I've then created a folder named "myparas"on my "h" drive and
named
the document "myparas".

I've then entered Para1, Para2 and Para 3 on the data source and put "Y"
underneath each of these headings.

In the middle of the main document (where I want the variable paragraphs
to
be inserted), I've inserted

{ INCLUDETEXT "h:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para1
\*Upper }"
= "Y" "Para1" "Para0" }
}{ INCLUDETEXT "h:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para2
\*Upper }" = "Y" "Para2" "Para0" }
}{ INCLUDETEXT "h:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para3
\*Upper }" = "Y" "Para3" "Para0" }
}

I've then followed the steps to set up a mailmerge, ie: inserted name,
address, etc, It does insert the address details, etc, but does not
appear
to link to the 'h' document. What step(s) am I missing?

Your advice would be greatly appreciated.

Regards
Sandra

Peter Jamieson wrote:
Hi Sandra,

I didn't provide the details because I hoped what you had would be enough.

NB - you can search by going to groups.google.com and entering a few
useful
keywords - if you search for INCLUDETEXT or AUTOTEXT and the name of one
of
the regular contributors here such as Meister Robbins Mayor or Jamieson
you
will probably find rather a lot of articles on these subjects. You can use
the advanced search there to restrict the search to the more recent
articles, which is usually helpful.

This is what you do, at least for INCLUDETEXT

Create a separate document - let's call it c;\myparas\myparas.doc

Insert the text chunks you want to use into that document.

Select each paragraph in turn and use Insert|Bookmark to bookmark each
paragraph with a different name - let's call them Para1,Para2,...,Para20.
It
may or may not be useful to bookmark the text chunks without their final
paragraph marks (click the Show/Hide button in the standard toolbar to
help
you do that).

Position the insertion point at the beginning of the document (so it's a
"point" selection) and insert a bookmark called Para0

In your mail merge main document, use

{ INCLUDETEXT "c:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para1
\*Upper }"
= "Y" "Para1" "Para0" }
}{ INCLUDETEXT "c:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para2
\*Upper }" = "Y" "Para2" "Para0" }
}{ INCLUDETEXT "c:\\myparas\\myparas.doc" { IF "{ MERGEFIELD Para3
\*Upper }" = "Y" "Para3" "Para0" }
}

etc.

As before, all the {} need to be the field braces you can insert using
ctrl-F9.

You have to do the INCLUDETEXT and IFs this way around or you end up with
{ IF condition "{ INCLUDETEXT something }" "" } and the same problems as
you
probably had before.

There are other ways to do this, but I think that's probably one of the
simpler methods.

Peter Jamieson

I currently have a database holding details of 400+ members.

[quoted text clipped - 28 lines]
Regards
Sandra


--
Message posted via http://www.officekb.com