Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data List for use in Mail Merge
Hi,
I am setting up a data list in excel of our investors names, addresses to be used in a mail merge in word. The list is going to actually be used to merge into several different types of letters (Capital Call Letters, Distribution Letters and Quarterly Letters). Some of the investors on this list will get quarterly letters only. Is there a way in excel to add a column to only select those who get quarterly letters only. I want to prevent doing a duplicate list of names and addresses for each letter. Can anyone help? -- Thank, Lori |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data List for use in Mail Merge
Instruction apply to Word 2003
In your data table create a column called Interval and used the initials of C, D and Q to indicate mailing criteria. Then in your word document click TOOLS in the menu and select Letters and Mailings and follow the steps to create a mergel letter. In Task Pane 3 of 6 one of the options is Edit Recipient list, click this option. A list of field names in the data source are at the top of each column of data and each field heading has a drop down list button. Click the drop down button on any column and select ADVANCED. In the FIELD combo box select the field to filter on. In the Comparison combo box select your operator Not equal to, equal to... and in the compare field enter your criteria. To omit your Quarterly recipients the field would be Interval, the comparison operator would be Not equal to and the compare to value would be Q. -- Kevin Backmann "Lori" wrote: Hi, I am setting up a data list in excel of our investors names, addresses to be used in a mail merge in word. The list is going to actually be used to merge into several different types of letters (Capital Call Letters, Distribution Letters and Quarterly Letters). Some of the investors on this list will get quarterly letters only. Is there a way in excel to add a column to only select those who get quarterly letters only. I want to prevent doing a duplicate list of names and addresses for each letter. Can anyone help? -- Thank, Lori |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
how do i set up a list of customers in excell for mail merge | Excel Discussion (Misc queries) | |||
mail merge- & data source - only taking 1st name in the list | Excel Discussion (Misc queries) |