| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge and paragraph formatting
The problem looks like this:
In an xlsx worksheet Row 1 contains three column names: €˜Line1, €˜Line2, €˜Line3. In Row 2, the first data row: the Line1 cell contains €˜one one one €¦. one one one in a line of text which runs over to two lines in a Word document; the Line2 cell is empty; the Line3 cell contains €˜three three three €¦ three three three, another overrunning line of text. A docx document uses Mail Merge for a Directory and for each record outputs Line1, Line2, and Line3 on succeeding lines, prefixed by identifying text, suppressing the line if the cell is empty, and applying the Hanging Indent paragraph format on each output line. So the output in this case should look like: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text I have encoded each line as (p+hi indicates a paragraph mark with hanging indent set): { IF { MERGEFIELD Linen } "" "Linen: { MERGEFIELD Linen }p+hi" "" } The paragraph mark is acted up on when field codes are shown so it all comes out as: { IF { MERGEFIELD Line1 } "" "Line1: { MERGEFIELD Line1 }p+hi " "" }{ IF { MERGEFIELD Line2 } "" "Line2: { MERGEFIELD Line2 }p+hi " "" }{ IF { MERGEFIELD Line3 } "" "Line3: { MERGEFIELD Line3 }p+hi " "" } However, in the result the lines are all indented, coming out like this: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text Can anyone tell me what's going on and how to fix it? -- Seamus O'Connell |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
And I did try so hard to get this exactly right ....
The hanging indent should of course look like: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text Seamus -- Seamus O'Connell "Seamus O'Connell" wrote: The problem looks like this: In an xlsx worksheet Row 1 contains three column names: €˜Line1, €˜Line2, €˜Line3. In Row 2, the first data row: the Line1 cell contains €˜one one one €¦. one one one in a line of text which runs over to two lines in a Word document; the Line2 cell is empty; the Line3 cell contains €˜three three three €¦ three three three, another overrunning line of text. A docx document uses Mail Merge for a Directory and for each record outputs Line1, Line2, and Line3 on succeeding lines, prefixed by identifying text, suppressing the line if the cell is empty, and applying the Hanging Indent paragraph format on each output line. So the output in this case should look like: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text I have encoded each line as (p+hi indicates a paragraph mark with hanging indent set): { IF { MERGEFIELD Linen } "" "Linen: { MERGEFIELD Linen }p+hi" "" } The paragraph mark is acted up on when field codes are shown so it all comes out as: { IF { MERGEFIELD Line1 } "" "Line1: { MERGEFIELD Line1 }p+hi " "" }{ IF { MERGEFIELD Line2 } "" "Line2: { MERGEFIELD Line2 }p+hi " "" }{ IF { MERGEFIELD Line3 } "" "Line3: { MERGEFIELD Line3 }p+hi " "" } However, in the result the lines are all indented, coming out like this: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text Can anyone tell me what's going on and how to fix it? -- Seamus O'Connell |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
In some ways of viewing this post the leading spaces are being lost.
The hanging indent text I'm trying to get has the first part of the line left-justified and the second overflow part indented. What is being produced by Mail Merge has both parts of the line indented. -- Seamus O'Connell "Seamus O'Connell" wrote: And I did try so hard to get this exactly right .... The hanging indent should of course look like: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text Seamus -- Seamus O'Connell "Seamus O'Connell" wrote: The problem looks like this: In an xlsx worksheet Row 1 contains three column names: €˜Line1, €˜Line2, €˜Line3. In Row 2, the first data row: the Line1 cell contains €˜one one one €¦. one one one in a line of text which runs over to two lines in a Word document; the Line2 cell is empty; the Line3 cell contains €˜three three three €¦ three three three, another overrunning line of text. A docx document uses Mail Merge for a Directory and for each record outputs Line1, Line2, and Line3 on succeeding lines, prefixed by identifying text, suppressing the line if the cell is empty, and applying the Hanging Indent paragraph format on each output line. So the output in this case should look like: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text I have encoded each line as (p+hi indicates a paragraph mark with hanging indent set): { IF { MERGEFIELD Linen } "" "Linen: { MERGEFIELD Linen }p+hi" "" } The paragraph mark is acted up on when field codes are shown so it all comes out as: { IF { MERGEFIELD Line1 } "" "Line1: { MERGEFIELD Line1 }p+hi " "" }{ IF { MERGEFIELD Line2 } "" "Line2: { MERGEFIELD Line2 }p+hi " "" }{ IF { MERGEFIELD Line3 } "" "Line3: { MERGEFIELD Line3 }p+hi " "" } However, in the result the lines are all indented, coming out like this: Line1: one one one etc€¦ one one one the overrunning part of Line1 text Line3: three three three etc€¦ three three three the overrunning part of Line3 text Can anyone tell me what's going on and how to fix it? -- Seamus O'Connell |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
Off the top of my head: have you tried formatting the paragraph(s) that
contain the { IF } field sequence with the formatting you want (i.e. as well as the paragraphs inside the IF field results)? Peter Jamieson http://tips.pjmsn.me.uk On 21/02/2010 17:50, Seamus O'Connell wrote: The problem looks like this: In an xlsx worksheet Row 1 contains three column names: €˜Line1, €˜Line2, €˜Line3. In Row 2, the first data row: the Line1 cell contains €˜one one one €¦. one one one in a line of text which runs over to two lines in a Word document; the Line2 cell is empty; the Line3 cell contains €˜three three three €¦ three three three, another overrunning line of text. A docx document uses Mail Merge for a Directory and for each record outputs Line1, Line2, and Line3 on succeeding lines, prefixed by identifying text, suppressing the line if the cell is empty, and applying the Hanging Indent paragraph format on each output line. So the output in this case should look like: Line1: one one oneetc€¦ one one onethe overrunning part of Line1 text Line3: three three threeetc€¦ three three threethe overrunning part of Line3 text I have encoded each line as (p+hi indicates a paragraph mark with hanging indent set): { IF { MERGEFIELD Linen } "" "Linen: { MERGEFIELD Linen }p+hi" "" } The paragraph mark is acted up on when field codes are shown so it all comes out as: { IF { MERGEFIELD Line1 } "" "Line1: { MERGEFIELD Line1 }p+hi " "" }{ IF { MERGEFIELD Line2 } "" "Line2: { MERGEFIELD Line2 }p+hi " "" }{ IF { MERGEFIELD Line3 } "" "Line3: { MERGEFIELD Line3 }p+hi " "" } However, in the result the lines are all indented, coming out like this: Line1: one one oneetc€¦ one one onethe overrunning part of Line1 text Line3: three three threeetc€¦ three three threethe overrunning part of Line3 text Can anyone tell me what's going on and how to fix it? |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
Peter - I tried formatting the entire document with Hanging Indent. Didn't work. Still got the first line of the generated paragraph indented the same as the second overflow line. But thanks for the thought. Seamus -- Seamus O'Connell "Peter Jamieson" wrote: Off the top of my head: have you tried formatting the paragraph(s) that contain the { IF } field sequence with the formatting you want (i.e. as well as the paragraphs inside the IF field results)? Peter Jamieson http://tips.pjmsn.me.uk |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
FWIW I can't make it do what you want. Word 2003 was slightly better in
this respect, but even setting the document compatibility to Word 2003 in Tools-Options does not appear to make a difference, so it must another change in the layout engine. Peter Jamieson http://tips.pjmsn.me.uk On 22/02/2010 00:36, Seamus O'Connell wrote: Peter - I tried formatting the entire document with Hanging Indent. Didn't work. Still got the first line of the generated paragraph indented the same as the second overflow line. But thanks for the thought. Seamus |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
The following field construction
{ IF { MERGEFIELD Line1 } "" "Line 1: { MERGEFIELD Line1 }¶ " "" }{ IF { MERGEFIELD Line2 } "" "Line 2: { MERGEFIELD Line2 }¶ " "" }{ IF { MERGEFIELD Line3 } "" "Line 1: { MERGEFIELD Line3 }¶ " "" }¶ where ¶ represents a carriage return, with each of those paragraphs formatted with the hanging indent provides the desired result in Word 2007 here. Copying and pasting the result into a plain text email message, the indents are lost, but in the word document each of the paragraphs starting with the word "Line" has a hanging indent. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. In the data source, record one contained data in all three fields, in record 2, the Line 1 field was empty, in record 3, the Line 2 field was empty and in Record 4, the Line 3 field was empty. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Seamus O'Connell" wrote in message ... Peter - I tried formatting the entire document with Hanging Indent. Didn't work. Still got the first line of the generated paragraph indented the same as the second overflow line. But thanks for the thought. Seamus -- Seamus O'Connell "Peter Jamieson" wrote: Off the top of my head: have you tried formatting the paragraph(s) that contain the { IF } field sequence with the formatting you want (i.e. as well as the paragraphs inside the IF field results)? Peter Jamieson http://tips.pjmsn.me.uk |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
Can we compare versions?
Here, I'm using Vista 32-bit SP2, Word 2007 SP2 Peter Jamieson http://tips.pjmsn.me.uk On 22/02/2010 06:19, Doug Robbins - Word MVP wrote: The following field construction { IF { MERGEFIELD Line1 } "" "Line 1: { MERGEFIELD Line1 }¶ " "" }{ IF { MERGEFIELD Line2 } "" "Line 2: { MERGEFIELD Line2 }¶ " "" }{ IF { MERGEFIELD Line3 } "" "Line 1: { MERGEFIELD Line3 }¶ " "" }¶ where ¶ represents a carriage return, with each of those paragraphs formatted with the hanging indent provides the desired result in Word 2007 here. Copying and pasting the result into a plain text email message, the indents are lost, but in the word document each of the paragraphs starting with the word "Line" has a hanging indent. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. In the data source, record one contained data in all three fields, in record 2, the Line 1 field was empty, in record 3, the Line 2 field was empty and in Record 4, the Line 3 field was empty. |
|
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge and paragraph formatting
Hi Peter,
The original test would have been on a 32-bit version of Vista (I cannot confirm that it was SP2 at the moment, but would be very surprised if it was not) and Word 2007 (also almost certainly SP2 (but I cannot confirm at the moment) I have just retested on a machine running Word 2007 SP2 under Windows 7, with an Excel 2010 data source (while I retained Word, I dumped the rest of Office when I installed 2010) and using the same field construction I get the expected result with one minor exception (which I had also experienced on the other installation) That is that the result of the first field in the first record appears as follows (here, I have manually inserted carriage returns and tabs to show the result Line 1: On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look Note that there is an empty "line" between the first and second lines. There is however no carriage return or new line "character" after the "the" at the end of the first line and according to the Paragraph Format dialog, the paragraph is formatted with single line spacing. If I change the line spacing in the Format Paragraph dialog from Single to Double and then back to Single again, this mystery space disappears. If I click undo to undo both instances of the paragraph formatting, the mystery line does not re-appear. If instead of using the Paragraph formatting dialog, I place the selection after the word "the" at the end of the first line and press delete, the first letter of the first word on the next line is deleted. Likewise, if I place the selection after the word "the" at the end of the first line and press the right arrow key, the selection moves the after the first letter of the first word on the next line. Apart from this anomaly with the result of the first field of the first record, all of the other paragraphs are formatted with the required hanging indent. -- Regards. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Peter Jamieson" wrote in message ... Can we compare versions? Here, I'm using Vista 32-bit SP2, Word 2007 SP2 Peter Jamieson http://tips.pjmsn.me.uk On 22/02/2010 06:19, Doug Robbins - Word MVP wrote: The following field construction { IF { MERGEFIELD Line1 } "" "Line 1: { MERGEFIELD Line1 }¶ " "" }{ IF { MERGEFIELD Line2 } "" "Line 2: { MERGEFIELD Line2 }¶ " "" }{ IF { MERGEFIELD Line3 } "" "Line 1: { MERGEFIELD Line3 }¶ " "" }¶ where ¶ represents a carriage return, with each of those paragraphs formatted with the hanging indent provides the desired result in Word 2007 here. Copying and pasting the result into a plain text email message, the indents are lost, but in the word document each of the paragraphs starting with the word "Line" has a hanging indent. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 3 To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. Line 1 On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. Line 2 You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. In the data source, record one contained data in all three fields, in record 2, the Line 1 field was empty, in record 3, the Line 2 field was empty and in Record 4, the Line 3 field was empty. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Conditional Paragraph Breaks With Mail Merge | Mailmerge | |||
| Paragraph formatting w/Mail Merge | Mailmerge | |||
| Mail Merge fields merge with different formatting | Microsoft Word Help | |||
| Formatting merge fields: inserting a paragraph mark before a field | Mailmerge | |||
| can you insert a paragraph into a mail merge letter | Mailmerge | |||
Hybrid Mode
