[Elise J]

Doing a mail merge to labels. My data source has all the information
required. However, when I do the merge, some of the data is not being merged
into the label format. Help!.

[Doug Robbins - Word MVP]

Probably because you are using the Addressblock which causes more problems
than it solves. Just insert the individual mergefields that you want to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the information
required. However, when I do the merge, some of the data is not being
merged
into the label format. Help!.

[Elise J]

Tried inserting the mergefields I needed, still missing data when perform the
merge. Did the match field thing and that is correct. It is sporatic on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more problems
than it solves. Just insert the individual mergefields that you want to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the information
required. However, when I do the merge, some of the data is not being
merged
into the label format. Help!.

[Peter Jamieson]

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news
Tried inserting the mergefields I needed, still missing data when perform
the
merge. Did the match field thing and that is correct. It is sporatic on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you want to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the information
required. However, when I do the merge, some of the data is not being
merged
into the label format. Help!.

[Elise J]

My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news
Tried inserting the mergefields I needed, still missing data when perform
the
merge. Did the match field thing and that is correct. It is sporatic on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you want to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the information
required. However, when I do the merge, some of the data is not being
merged
into the label format. Help!.

[Peter Jamieson]

As a possible workaround, try checking Word Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to the Excel sheet
again, select the DDE option when it is offered, and see if that makes a
difference.

Peter Jamieson
"Elise J" wrote in message
...
My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news
Tried inserting the mergefields I needed, still missing data when
perform
the
merge. Did the match field thing and that is correct. It is sporatic
on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you want
to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow
MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the
information
required. However, when I do the merge, some of the data is not
being
merged
into the label format. Help!.

[Elise J]

Just tried doing that, still missing data. Would the number of labels I need
to merge be a factor?

"Peter Jamieson" wrote:

As a possible workaround, try checking Word Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to the Excel sheet
again, select the DDE option when it is offered, and see if that makes a
difference.

Peter Jamieson
"Elise J" wrote in message
...
My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news Tried inserting the mergefields I needed, still missing data when
perform
the
merge. Did the match field thing and that is correct. It is sporatic
on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you want
to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow
MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the
information
required. However, when I do the merge, some of the data is not
being
merged
into the label format. Help!.

[Peter Jamieson]

It's always possible. Are there a lot?

Something you can try for now:
a. select your two columns in Excel
b. Edit|Copy
c. create a new document in Word
d. Edit|Paste, creating a two-column table in Word
e. use the Word document as the data source for your merge

Peter Jamieson

"Elise J" wrote in message
...
Just tried doing that, still missing data. Would the number of labels I
need
to merge be a factor?

"Peter Jamieson" wrote:

As a possible workaround, try checking Word
Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to the Excel
sheet
again, select the DDE option when it is offered, and see if that makes a
difference.

Peter Jamieson
"Elise J" wrote in message
...
My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news Tried inserting the mergefields I needed, still missing data when
perform
the
merge. Did the match field thing and that is correct. It is
sporatic
on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you
want
to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow
MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the
information
required. However, when I do the merge, some of the data is not
being
merged
into the label format. Help!.

[Elise J]

Still missing info. I will presume the version I am using cannot handle a
large quantity of data for a label merge and do this the long way.

"Peter Jamieson" wrote:

It's always possible. Are there a lot?

Something you can try for now:
a. select your two columns in Excel
b. Edit|Copy
c. create a new document in Word
d. Edit|Paste, creating a two-column table in Word
e. use the Word document as the data source for your merge

Peter Jamieson

"Elise J" wrote in message
...
Just tried doing that, still missing data. Would the number of labels I
need
to merge be a factor?

"Peter Jamieson" wrote:

As a possible workaround, try checking Word
Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to the Excel
sheet
again, select the DDE option when it is offered, and see if that makes a
difference.

Peter Jamieson
"Elise J" wrote in message
...
My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" wrote in message
news Tried inserting the mergefields I needed, still missing data when
perform
the
merge. Did the match field thing and that is correct. It is
sporatic
on
the data it is not merging. Using Word 2002 - is this the problem?

"Doug Robbins - Word MVP" wrote:

Probably because you are using the Addressblock which causes more
problems
than it solves. Just insert the individual mergefields that you
want
to
appear on the labels in the configuration that you want.

Also, see the article "Mail Merge to Labels with Word XP" on fellow
MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
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

"Elise J" Elise wrote in message
...
Doing a mail merge to labels. My data source has all the
information
required. However, when I do the merge, some of the data is not
being
merged
into the label format. Help!.