Re: Merging to labels

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" <EliseJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A1401DF-CC58-41BC-844D-FCC89109D08B@xxxxxxxxxxxxxxxx
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" <EliseJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6777F479-A2BD-4C10-9034-E313D46A3A1F@xxxxxxxxxxxxxxxx
My data source is an excel file, only two columns.

"Peter Jamieson" wrote:

What is the data source?

Peter Jamieson
"Elise J" <EliseJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D06B2247-B000-4E25-A169-E3B3B8FED7E4@xxxxxxxxxxxxxxxx
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_labels_with_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 J@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:60E22645-1553-4E4C-AA0E-66F04573BAE3@xxxxxxxxxxxxxxxx
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!.












.

Relevant Pages

  • Re: merge is pulling in every other record?
    ... I should have said KillmapS ... "Peter Jamieson" wrote: ... and the excel spreadsheet for you to look at. ... The first two records (labels) merge fine - top left label, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: merge is pulling in every other record?
    ... "Peter Jamieson" wrote: ... and the excel spreadsheet for you to look at. ... take "Killmap" out of my address and send them. ... The first two records (labels) merge fine - top left label, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: merge is pulling in every other record?
    ... Peter Jamieson ... and the excel spreadsheet for you to look at. ... character like a circle with four lines coming out from the four ... The first two records (labels) merge fine - top left label, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Printing Variable Label Quantities from a Merge
    ... "Peter Jamieson" wrote: ... following crude bit of Excel VBA code should delete any existing ... its label generator may be worth investigation ... What type of database is it? ...
    (microsoft.public.word.docmanagement)
  • Re: merge using excel
    ... "Peter Jamieson" wrote: ... If you really need to use a label type merge, then you do have to copy the ... What version of Excel was the Workbook created in? ...
    (microsoft.public.word.mailmerge.fields)