View Single Post
  #4   Report Post  
Posted to microsoft.public.word.pagelayout
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge into columns with variable length data?

Sounds like you are trying to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


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

"Nigel Molesworth" wrote in message
news
On Fri, 18 Jan 2008 13:25:10 +1000, "Doug Robbins - Word MVP"
wrote:

Use a Directory, (or Catalog in versions before Word XP) type mail merge
main document with a one row three column table in it and insert the
mergefields into the cells of that table.


OK, I'm getting somewhere - I think.

The following adds the text "Tel:" and the phone number for records with a
phone number, but I can only check this by manually going to the next
record
in the Preview group on the ribbon. Despite the Next Record it will
only
insert a single entry, not the whole database.

Surname: HisName [CR]
{IF {MERGEFIELD TEL}"" "Tel:" ""}Tel [CR]
Next Record