Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copies to:
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Thanks Andrea
While I was waiting for a reply, I tried a few things, one of which worked! I went to my Word data source document and added a column with the heading row "Allnames". In the first person's record, I inserted all the names (not too many, fortunately) into this column with paragraph breaks between each one. I pasted these to the other records and then just had to go through and delete one name from each record the Allnames column. When I inserted "Allnames" after "cc" in my letter, I got precisely what I needed! Thanks again. a9 "Andrea Jones" wrote in message ... 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? |
#4
|
|||
|
|||
Thanks Andrea
While I was waiting for a reply, I tried a few things, one of which worked! I went to my Word data source document and added a column with the heading row "Allnames". In the first person's record, I inserted all the names (not too many, fortunately) into this column with paragraph breaks between each one. I pasted these to the other records and then just had to go through and delete one name from each record the Allnames column. When I inserted "Allnames" after "cc" in my letter, I got precisely what I needed! Thanks again. a9 "Andrea Jones" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restoring "Number of copies" print default? | Microsoft Word Help | |||
I am having trouble printing multiple copies in Word 2003. Excel. | Microsoft Word Help | |||
trouble printing mulitple copies | Microsoft Word Help | |||
Why get multiple copies of file when try to delete | Microsoft Word Help | |||
Printing Defaults - # of Copies | Page Layout |