Using custom Label word merge - data dropped

Have an 8 pg custom Label word merge doc w/excel file as data source. First
page prints all data perfectly of 4 short lines. 2nd page & rest of doc.
places a zero in a field that should have (example) 354k4. Field is formatted
as General. Don't know why the number/letter combo isn't appearing, instead
shows as a zero.
--
jlem102

Format the data as text rather than general
or
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"jlem102" wrote in message
...
Have an 8 pg custom Label word merge doc w/excel file as data source.
First
page prints all data perfectly of 4 short lines. 2nd page & rest of doc.
places a zero in a field that should have (example) 354k4. Field is
formatted
as General. Don't know why the number/letter combo isn't appearing,
instead
shows as a zero.
--
jlem102

As long as the number of columns is reasonably small, it is probably
simplest to edit-copy your sheet, or the columns you are using, then
edit-paste into a new Word document. The data should appear as a table
(unless you have too many columns). Save that, and use it as the data
source for your merge.

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/03/2010 22:20, jlem102 wrote:
Have an 8 pg custom Label word merge doc w/excel file as data source. First
page prints all data perfectly of 4 short lines. 2nd page& rest of doc.
places a zero in a field that should have (example) 354k4. Field is formatted
as General. Don't know why the number/letter combo isn't appearing, instead
shows as a zero.

New news...The data source columns are all set up as General in excel.
Column starts with data as ie. 12345, then data changes to i.e. 123K5, so
when you pull the data into word as a word merge, the columns of data
mysteriouly changes data to zeros when the data changed to 123k5 type data.
Had to break down the merged file into pages and manually key in data needed.
Not fun !
--
jlem102


"Peter Jamieson" wrote:

As long as the number of columns is reasonably small, it is probably
simplest to edit-copy your sheet, or the columns you are using, then
edit-paste into a new Word document. The data should appear as a table
(unless you have too many columns). Save that, and use it as the data
source for your merge.

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/03/2010 22:20, jlem102 wrote:
Have an 8 pg custom Label word merge doc w/excel file as data source. First
page prints all data perfectly of 4 short lines. 2nd page& rest of doc.
places a zero in a field that should have (example) 354k4. Field is formatted
as General. Don't know why the number/letter combo isn't appearing, instead
shows as a zero.
.

It is the change in data type (the set up of the columns to General is only
for appearance) that is causing your problem. Copying and pasting the data
into a Word document as Peter suggests would be a simple way of overcoming
the issue.

--
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, originally posted via msnews.microsoft.com

"jlem102" wrote in message
news
New news...The data source columns are all set up as General in excel.
Column starts with data as ie. 12345, then data changes to i.e. 123K5, so
when you pull the data into word as a word merge, the columns of data
mysteriouly changes data to zeros when the data changed to 123k5 type
data.
Had to break down the merged file into pages and manually key in data
needed.
Not fun !
--
jlem102


"Peter Jamieson" wrote:

As long as the number of columns is reasonably small, it is probably
simplest to edit-copy your sheet, or the columns you are using, then
edit-paste into a new Word document. The data should appear as a table
(unless you have too many columns). Save that, and use it as the data
source for your merge.

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/03/2010 22:20, jlem102 wrote:
Have an 8 pg custom Label word merge doc w/excel file as data source.
First
page prints all data perfectly of 4 short lines. 2nd page& rest of
doc.
places a zero in a field that should have (example) 354k4. Field is
formatted
as General. Don't know why the number/letter combo isn't appearing,
instead
shows as a zero.
.