Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge into Word 97
Hi
Can anyone advise me how to create an IF command in an Excel data source which will enable any letter created in word to include a sentence if the Postcode entered is included in the 'IF' cell. To clarify I need to input a sentence into a word document which has data entered via mail merge but only if the postode is equal to any one of three codes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge into Word 97
it might be faster just to sort the excel data, split it into two sheets, one
with the 3 postal codes and one withtout, and do two different merges. "ADJS" wrote: Hi Can anyone advise me how to create an IF command in an Excel data source which will enable any letter created in word to include a sentence if the Postcode entered is included in the 'IF' cell. To clarify I need to input a sentence into a word document which has data entered via mail merge but only if the postode is equal to any one of three codes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge into Word 97
Can anyone advise me how to create an IF command in an Excel data
source which will enable any letter created in word to include a sentence if the Postcode entered is included in the 'IF' cell. To clarify I need to input a sentence into a word document which has data entered via mail merge but only if the postode is equal to any one of three codes. Maybe it would work to have an "IF" column, where each cell evaluates to either an empty string or the desired sentence. Then include this as another merge field. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge with Word | New Users to Excel | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
Mail merge to word | Excel Discussion (Misc queries) | |||
in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) |