A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail merge data not showing on Mail Recipient List



 
 
Thread Tools Display Modes
  #1  
Old October 24th 06, 09:01 PM posted to microsoft.public.word.mailmerge.fields
Connie G
external usenet poster
 
Posts: 1
Default Mail merge data not showing on Mail Recipient List

I am trying to create a mail merge from Excel spreadsheet, and Mail recipient
list does not show data from several columns in mail recipient list, even
though the data is there. The list has think black lines instead of the
data. How can I fix this problem?

Thanks so much for your help,
Connie G
Ads
  #2  
Old October 25th 06, 12:31 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Mail merge data not showing on Mail Recipient List

The list has think black lines instead of the
data. How can I fix this problem?


Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list, even
though the data is there. The list has think black lines instead of the
data. How can I fix this problem?

Thanks so much for your help,
Connie G



  #3  
Old October 25th 06, 08:16 PM posted to microsoft.public.word.mailmerge.fields
Connie G
external usenet poster
 
Posts: 3
Default Mail merge data not showing on Mail Recipient List

Hi Peter,
From Word merge doc, I open the Mail Recipient List and all the column
headers show (there's about 20 columns), but data for columns B & C only is
missing - there is a thick (:) black line followed by dots where data should
be.

As a test, I copied and did a paste special into a blank spreadsheet, and
the merge works fine if there are no formulas; however, I'd prefer to fix the
problem and avoid this extra step, since there are already several steps
before getting to the merge itself. Columns B&C contain a VLookup formula,
but several other columns do as well, and they show up OK.

Thank you for your help in investigating this problem.
Connie G.

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?


Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list, even
though the data is there. The list has think black lines instead of the
data. How can I fix this problem?

Thanks so much for your help,
Connie G




  #4  
Old October 25th 06, 08:21 PM posted to microsoft.public.word.mailmerge.fields
Connie G
external usenet poster
 
Posts: 3
Default Mail merge data not showing on Mail Recipient List

P.S. I'm working in Word/Excel 2003 with Windows XP Professional. Thanks

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?


Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list, even
though the data is there. The list has think black lines instead of the
data. How can I fix this problem?

Thanks so much for your help,
Connie G




  #5  
Old October 26th 06, 12:08 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Mail merge data not showing on Mail Recipient List

OK, can't look right now, but are the vlookup columns that fail returning
long texts (probably longer than around 255 characters?) or mixed field
types (some text, some numeric). If so, how about the vlookups that succeed?


Peter Jamieson

"Connie G" wrote in message
...
Hi Peter,
From Word merge doc, I open the Mail Recipient List and all the column
headers show (there's about 20 columns), but data for columns B & C only
is
missing - there is a thick (:) black line followed by dots where data
should
be.

As a test, I copied and did a paste special into a blank spreadsheet, and
the merge works fine if there are no formulas; however, I'd prefer to fix
the
problem and avoid this extra step, since there are already several steps
before getting to the merge itself. Columns B&C contain a VLookup
formula,
but several other columns do as well, and they show up OK.

Thank you for your help in investigating this problem.
Connie G.

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?


Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data
are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the
ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect
to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list,
even
though the data is there. The list has think black lines instead of
the
data. How can I fix this problem?

Thanks so much for your help,
Connie G






  #6  
Old October 26th 06, 02:28 PM posted to microsoft.public.word.mailmerge.fields
Connie G
external usenet poster
 
Posts: 3
Default Mail merge data not showing on Mail Recipient List

Hi Peter - The problem columns, B and C, return names; the other vlookup
columns return numbers.
Thanks,
Connie

"Peter Jamieson" wrote:

OK, can't look right now, but are the vlookup columns that fail returning
long texts (probably longer than around 255 characters?) or mixed field
types (some text, some numeric). If so, how about the vlookups that succeed?


Peter Jamieson

"Connie G" wrote in message
...
Hi Peter,
From Word merge doc, I open the Mail Recipient List and all the column
headers show (there's about 20 columns), but data for columns B & C only
is
missing - there is a thick (:) black line followed by dots where data
should
be.

As a test, I copied and did a paste special into a blank spreadsheet, and
the merge works fine if there are no formulas; however, I'd prefer to fix
the
problem and avoid this extra step, since there are already several steps
before getting to the merge itself. Columns B&C contain a VLookup
formula,
but several other columns do as well, and they show up OK.

Thank you for your help in investigating this problem.
Connie G.

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?

Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data
are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the
ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect
to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list,
even
though the data is there. The list has think black lines instead of
the
data. How can I fix this problem?

Thanks so much for your help,
Connie G






  #7  
Old October 26th 06, 04:17 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Mail merge data not showing on Mail Recipient List

Hi Connie,

OK, so far I have been unable to make my VLOOKUPS fail, but my sample data
may be too simple. The info. that it is apparently only the text fields that
fail may well be significant but so far there is no difference here.

If you can replicate the problem using test data that you feel able to send
me, you are welcome to de-SPAM my e-mail address (remove "KillmapS") and
e-mail me your xls file(s) and a mail merge main document, and I will have a
look. Please let me know which version of Word/Excel you are using.

Peter Jamieson

"Connie G" wrote in message
...
Hi Peter - The problem columns, B and C, return names; the other vlookup
columns return numbers.
Thanks,
Connie

"Peter Jamieson" wrote:

OK, can't look right now, but are the vlookup columns that fail returning
long texts (probably longer than around 255 characters?) or mixed field
types (some text, some numeric). If so, how about the vlookups that
succeed?


Peter Jamieson

"Connie G" wrote in message
...
Hi Peter,
From Word merge doc, I open the Mail Recipient List and all the column
headers show (there's about 20 columns), but data for columns B & C
only
is
missing - there is a thick (:) black line followed by dots where data
should
be.

As a test, I copied and did a paste special into a blank spreadsheet,
and
the merge works fine if there are no formulas; however, I'd prefer to
fix
the
problem and avoid this extra step, since there are already several
steps
before getting to the merge itself. Columns B&C contain a VLookup
formula,
but several other columns do as well, and they show up OK.

Thank you for your help in investigating this problem.
Connie G.

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?

Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in
each
cell, or do you mean that the vertical lines between the columns of
data
are
thicker than usual (not sure whether you meant "thin" or "thick" when
you
said "think" :-) But in either case I haven't seen this before so am
just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps,
the
ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then
reconnect
to
your data source and choose the DDE option when it is offered. It may
not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie
wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list,
even
though the data is there. The list has think black lines instead of
the
data. How can I fix this problem?

Thanks so much for your help,
Connie G








 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM
How do I print a recipient list in a mail merge document in XP MoiraT Mailmerge 1 June 8th 06 12:16 PM
Editing Mail Merge Recipients Stan W. Mailmerge 8 May 4th 06 05:03 AM
Mail Merge Recipient List Lambi000 Mailmerge 2 April 19th 05 12:35 PM
can data fields be added to an exisiting mail merge address list missode Microsoft Word Help 1 December 19th 04 11:29 PM


All times are GMT +1. The time now is 01:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.