If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
merge info into table
When I try to merge from an excel file to create a table of several rows, I
created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#2
|
|||
|
|||
merge info into table
Is this a blank row or an empty paragraph?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#3
|
|||
|
|||
merge info into table
Suzanne: Thanks for getting back to me.
It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#4
|
|||
|
|||
merge info into table
Table | Show Gridlines. If it's an empty row, you'll see an empty row.
Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#5
|
|||
|
|||
merge info into table
Suzanne:
I see an empty row (nothing). Table/show gridlines shows nothing. Ctl+* does nothing. I see no paragraph mark. -- Yes, I'm trying to create catalog/directory merge. I want a table with my data inside (but with no blank lines between entries.) -- When I create the one row table should I be careful I not to put a hard return in last before saving? "Suzanne S. Barnhill" wrote: Table | Show Gridlines. If it's an empty row, you'll see an empty row. Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#6
|
|||
|
|||
merge info into table
Suzane
I've found out how to reveal format marks. (Tools etc). I see a paragraph mark between the rows of my final document. If I delete them the doc prints fine. But how do I prevent them in the first place. On the one-row-table-to-be-merged-into I also see the paragraph mark on the line below the one-row table, but I can't delete it. "Cyrus" wrote: Suzanne: I see an empty row (nothing). Table/show gridlines shows nothing. Ctl+* does nothing. I see no paragraph mark. -- Yes, I'm trying to create catalog/directory merge. I want a table with my data inside (but with no blank lines between entries.) -- When I create the one row table should I be careful I not to put a hard return in last before saving? "Suzanne S. Barnhill" wrote: Table | Show Gridlines. If it's an empty row, you'll see an empty row. Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#7
|
|||
|
|||
merge info into table
Suzanne
Aha! I've found that if I remove the paragraph mark before the table then the table prints fine. Thanks for sticking w me on this. Now I have another problem: I have some colored text in my excel source file, but when I merge into the table the text is black. How do I keep the colored text? "Cyrus" wrote: Suzane I've found out how to reveal format marks. (Tools etc). I see a paragraph mark between the rows of my final document. If I delete them the doc prints fine. But how do I prevent them in the first place. On the one-row-table-to-be-merged-into I also see the paragraph mark on the line below the one-row table, but I can't delete it. "Cyrus" wrote: Suzanne: I see an empty row (nothing). Table/show gridlines shows nothing. Ctl+* does nothing. I see no paragraph mark. -- Yes, I'm trying to create catalog/directory merge. I want a table with my data inside (but with no blank lines between entries.) -- When I create the one row table should I be careful I not to put a hard return in last before saving? "Suzanne S. Barnhill" wrote: Table | Show Gridlines. If it's an empty row, you'll see an empty row. Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#8
|
|||
|
|||
merge info into table
Assuming that the color is created by conditional formatting in Excel, you
can't carry that over into Word. You *may* (using IF) fields be able to replicate this in Word, but if you have more than two colors (black and a color), you'll need nested IF fields. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne Aha! I've found that if I remove the paragraph mark before the table then the table prints fine. Thanks for sticking w me on this. Now I have another problem: I have some colored text in my excel source file, but when I merge into the table the text is black. How do I keep the colored text? "Cyrus" wrote: Suzane I've found out how to reveal format marks. (Tools etc). I see a paragraph mark between the rows of my final document. If I delete them the doc prints fine. But how do I prevent them in the first place. On the one-row-table-to-be-merged-into I also see the paragraph mark on the line below the one-row table, but I can't delete it. "Cyrus" wrote: Suzanne: I see an empty row (nothing). Table/show gridlines shows nothing. Ctl+* does nothing. I see no paragraph mark. -- Yes, I'm trying to create catalog/directory merge. I want a table with my data inside (but with no blank lines between entries.) -- When I create the one row table should I be careful I not to put a hard return in last before saving? "Suzanne S. Barnhill" wrote: Table | Show Gridlines. If it's an empty row, you'll see an empty row. Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
#9
|
|||
|
|||
merge info into table
Suzanne
Thanks. You've helped a lot. Over and out. For now. Cyrus "Suzanne S. Barnhill" wrote: Assuming that the color is created by conditional formatting in Excel, you can't carry that over into Word. You *may* (using IF) fields be able to replicate this in Word, but if you have more than two colors (black and a color), you'll need nested IF fields. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne Aha! I've found that if I remove the paragraph mark before the table then the table prints fine. Thanks for sticking w me on this. Now I have another problem: I have some colored text in my excel source file, but when I merge into the table the text is black. How do I keep the colored text? "Cyrus" wrote: Suzane I've found out how to reveal format marks. (Tools etc). I see a paragraph mark between the rows of my final document. If I delete them the doc prints fine. But how do I prevent them in the first place. On the one-row-table-to-be-merged-into I also see the paragraph mark on the line below the one-row table, but I can't delete it. "Cyrus" wrote: Suzanne: I see an empty row (nothing). Table/show gridlines shows nothing. Ctl+* does nothing. I see no paragraph mark. -- Yes, I'm trying to create catalog/directory merge. I want a table with my data inside (but with no blank lines between entries.) -- When I create the one row table should I be careful I not to put a hard return in last before saving? "Suzanne S. Barnhill" wrote: Table | Show Gridlines. If it's an empty row, you'll see an empty row. Ctrl+* to display nonprinting characters. If it's an empty paragraph, you'll see a paragraph mark. I assume you're creating a catalog/directory-type merge. When you do this, you need to include just *one* table row followed by the default empty paragraph. If you have an extra paragraph or table row, this will be replicated for every record. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... Suzanne: Thanks for getting back to me. It looks like a blank line below the one-line tables. It could be a blank row or a blank paragraph. I could email you what I see if you like. Cyrus "Suzanne S. Barnhill" wrote: Is this a blank row or an empty paragraph? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cyrus" wrote in message ... When I try to merge from an excel file to create a table of several rows, I created a table of one row with merge data inside. When I look at completed doc I find a blank space between all entries. How do I merge into a table without the blanks space between rows? Is the cursor position significant? I've tried saving w the cursor in every position possible. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Lily@Insight | Mailmerge | 24 | January 15th, 2007 10:33 PM |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 01:36 AM |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 04:56 AM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 12:55 PM |