A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

merge info into table



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2006, 09:09 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 21st, 2006, 09:22 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 03:59 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 05:37 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 07:34 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 07:48 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 08:37 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 22nd, 2006, 11:34 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old March 23rd, 2006, 04:44 AM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.