Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
HI,
I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
Tell us some more about how you have this set up.
-- 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 "haliburton girl" wrote in message ... HI, I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
Hi Doug,
I have tried to copy and paste the formulas in this email box but it only comes out in "word" form, not formulas. I am making a directory of names, with address, etc and then a list of their interests. The Word doc. merges with an excel file and works great. I had trouble with commas last year but fixed that. the IF statements run as follows: funny bracket IF funny bracket "biography" funny bracket"" "funny bracket "biography" \*charformat funny bracket, " funny bracket then it starts to the next one. I am sorry but I can't find the funny bracket to make it clearer! I get a list: songwriting, biography, devotionals, But always the last one in the list ends with a comma and I would like it to end with a period. Like so. songwriting, biography, devotionals. Can you help me with the formula? "Doug Robbins - Word MVP" wrote: Tell us some more about how you have this set up. -- 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 "haliburton girl" wrote in message ... HI, I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
You should use a formula in the Excel file that combines the interests an
inserts the commas and period where required all into one cell that you then merge into Word. Easier than using the formula in Word. But in Word, you would use the formula { IF { MERGEFIELD Biography } "" { MERGEFIELD Biography } }{IF { MERGEFIELD NextInterest } "" ", { MERGEFIELD NextInterest } "." } etc. That is the comma and the space is only inserted if the next interest exists, otherwise a period is inserted. You must use Ctrl+F9 to insert the { } and you use Alt+F9 to toggle off their display. -- 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 "haliburton girl" wrote in message ... Hi Doug, I have tried to copy and paste the formulas in this email box but it only comes out in "word" form, not formulas. I am making a directory of names, with address, etc and then a list of their interests. The Word doc. merges with an excel file and works great. I had trouble with commas last year but fixed that. the IF statements run as follows: funny bracket IF funny bracket "biography" funny bracket"" "funny bracket "biography" \*charformat funny bracket, " funny bracket then it starts to the next one. I am sorry but I can't find the funny bracket to make it clearer! I get a list: songwriting, biography, devotionals, But always the last one in the list ends with a comma and I would like it to end with a period. Like so. songwriting, biography, devotionals. Can you help me with the formula? "Doug Robbins - Word MVP" wrote: Tell us some more about how you have this set up. -- 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 "haliburton girl" wrote in message ... HI, I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
Doug,
Just a quick question: Do I actually insert the word nextinterest or is that where I type in the next interest? And do I do that for each of the 16 interests that I have listed? Jan "Doug Robbins - Word MVP" wrote: You should use a formula in the Excel file that combines the interests an inserts the commas and period where required all into one cell that you then merge into Word. Easier than using the formula in Word. But in Word, you would use the formula { IF { MERGEFIELD Biography } "" { MERGEFIELD Biography } }{IF { MERGEFIELD NextInterest } "" ", { MERGEFIELD NextInterest } "." } etc. That is the comma and the space is only inserted if the next interest exists, otherwise a period is inserted. You must use Ctrl+F9 to insert the { } and you use Alt+F9 to toggle off their display. -- 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 "haliburton girl" wrote in message ... Hi Doug, I have tried to copy and paste the formulas in this email box but it only comes out in "word" form, not formulas. I am making a directory of names, with address, etc and then a list of their interests. The Word doc. merges with an excel file and works great. I had trouble with commas last year but fixed that. the IF statements run as follows: funny bracket IF funny bracket "biography" funny bracket"" "funny bracket "biography" \*charformat funny bracket, " funny bracket then it starts to the next one. I am sorry but I can't find the funny bracket to make it clearer! I get a list: songwriting, biography, devotionals, But always the last one in the list ends with a comma and I would like it to end with a period. Like so. songwriting, biography, devotionals. Can you help me with the formula? "Doug Robbins - Word MVP" wrote: Tell us some more about how you have this set up. -- 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 "haliburton girl" wrote in message ... HI, I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
directory
nextinterest was an alias for what I assume are the individual fields in
your data source. How is the data arranged? -- 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 "haliburton girl" wrote in message ... Doug, Just a quick question: Do I actually insert the word nextinterest or is that where I type in the next interest? And do I do that for each of the 16 interests that I have listed? Jan "Doug Robbins - Word MVP" wrote: You should use a formula in the Excel file that combines the interests an inserts the commas and period where required all into one cell that you then merge into Word. Easier than using the formula in Word. But in Word, you would use the formula { IF { MERGEFIELD Biography } "" { MERGEFIELD Biography } }{IF { MERGEFIELD NextInterest } "" ", { MERGEFIELD NextInterest } "." } etc. That is the comma and the space is only inserted if the next interest exists, otherwise a period is inserted. You must use Ctrl+F9 to insert the { } and you use Alt+F9 to toggle off their display. -- 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 "haliburton girl" wrote in message ... Hi Doug, I have tried to copy and paste the formulas in this email box but it only comes out in "word" form, not formulas. I am making a directory of names, with address, etc and then a list of their interests. The Word doc. merges with an excel file and works great. I had trouble with commas last year but fixed that. the IF statements run as follows: funny bracket IF funny bracket "biography" funny bracket"" "funny bracket "biography" \*charformat funny bracket, " funny bracket then it starts to the next one. I am sorry but I can't find the funny bracket to make it clearer! I get a list: songwriting, biography, devotionals, But always the last one in the list ends with a comma and I would like it to end with a period. Like so. songwriting, biography, devotionals. Can you help me with the formula? "Doug Robbins - Word MVP" wrote: Tell us some more about how you have this set up. -- 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 "haliburton girl" wrote in message ... HI, I am making a directory again this year. It is all working well, even the commas in the list. However, at the end of the list of each person, there is a comma where I would like a period. Can you tell me the correct way to make it know that it is the end of the list and put a period. thanks, |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up an index directory in a Word doc does NOT work / "No index entries found" | Microsoft Word Help | |||
How to change the directory which word defaults to when opening a | Microsoft Word Help | |||
How to change the directory which word defaults to when opening a | Microsoft Word Help | |||
Edit Hyperlink Default Directory | Microsoft Word Help | |||
Slow Open directory read | Microsoft Word Help |