Thread: Copies to:
View Single Post
  #2   Report Post  
Andrea Jones
 
Posts: n/a
Default

I suppose you could do it by using the database toolbar (see
http://www.allaboutoffice.co.uk/worddatabase.htm) to add a table of all the
names from your data source except the person receiving that letter (i.e. the
query options would have to be that NAME Is Not Equal To MERGEFIELD NAME). On
the Select Fields section of the query window remove all the fields except
the NAME field and remove the tick from the 'Show field names' box. Set the
Table AutoFormat to None so you don't get any borders around it. When you're
setting up the database field type in anything for the comparison value in
the 'Not equals to' statement. When you've made the database fields press
ALT+F9 and delete the name you entered from the statement replacing it with
{MERGEFIELD NAME} (press CTRL+F9 to get the curly braces) where NAME is
whatever your field is called. When you are creating the database field make
sure you tick the 'Insert table as a field' box or you won't be able to make
it interact with your mail merge.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com


"a9" wrote:

I have set up a mail merge for a letter from a Word data source. At the end
of the letter, I would like to show the names of the other people the letter
is sent to, i.e. cc:

Is this possible please and, if so, what sort of field do I need?