Re: Label Mail Merge puts each line of address on a new label

Tech-Archive recommends: Speed Up your PC by fixing your registry

It would be better to convert the file to Excel so that you could use a
column as a field identifier for sorting/printing. Each record needs to be
on a single row w/a column for each field, not in a stacked format.
Publisher can then use this directly from Excel or you can create a .csv
file. Publisher can use either. Since you have the file in Word format,
converting it to a single record per line layout is no more difficult to do
than replacing the field delimiters. In Word all you need to do is
'Table/Convert Text to Table'. To make this work it is necessary to insure
that each address record has the same number of lines (including blank
lines). i.e. There must be the same number of lines from the first line of
one record to the first lines of each succeeding record. The table would
have that same number of columns.

If this doesn't seem clear, send me a private email and if the file isn't
outrageously large you can attach it. I'll do the conversion and send it
back to you.
--
Ron Cohen

"Sagit" <Sagit@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:57F0B684-290C-4F58-84BA-8682DFBF3DEC@xxxxxxxxxxxxxxxx
>I have an address file originally created by an old non- microsoft program.
> In order to create labels with this file, I copy it into Word, replace the
> record and field delimiters with those recognizable by Word and do a mail
> merge. But, I need to use Publisher, because most of the time, I need to
> be
> able to pick and choose which addresses to print. I can't use a filter,
> since
> this file is not in Excel, Access, etc. I've tried getting it in those,
> and
> couldn't. It always stays stacked.
> My problem is that after saving the Word address file as a text file (the
> only way Publisher recognized it as a table) Publisher puts each line of
> the
> addres on a new label.
> The address file is stacked, with a record delimiter at the beginning of
> the
> first line (Company name), underneath that is the person's name, then
> underneath that is a field delimiter with the street address, then under
> that
> is the rest of the address, with no additional delimiters.
> My boss will be forever grateful if you can help me solve this. Thank you
> in advance.
> S Jan


.

Relevant Pages

  • Re: Label Mail Merge puts each line of address on a new label
    ... You really need to stick that mailing list into Excel. ... > record and field delimiters with those recognizable by Word and do a mail ... But, I need to use Publisher, because most of the time, I need to ... > underneath that is a field delimiter with the street address, ...
    (microsoft.public.publisher)
  • Re: Label Mail Merge puts each line of address on a new label
    ... used in Excel or output as a .csv file. ... >>> record and field delimiters with those recognizable by Word and do a ... But, I need to use Publisher, because most of the time, I need ... >>> first line, underneath that is the person's name, then ...
    (microsoft.public.publisher)
  • Re: Label Mail Merge puts each line of address on a new label
    ... I would love to get it in Excel, but have not found a way to do it properly. ... >> record and field delimiters with those recognizable by Word and do a mail ... But, I need to use Publisher, because most of the time, I need to ... >> underneath that is a field delimiter with the street address, ...
    (microsoft.public.publisher)
  • Re: Label Mail Merge puts each line of address on a new label
    ... Also, I did do a "convert text to table", but Publisher did not ... >> Publisher can then use this directly from Excel or you can create a .csv ... >> than replacing the field delimiters. ... >>> first line, underneath that is the person's name, then ...
    (microsoft.public.publisher)
  • Label Mail Merge puts each line of address on a new label
    ... In order to create labels with this file, I copy it into Word, replace the ... record and field delimiters with those recognizable by Word and do a mail ... But, I need to use Publisher, because most of the time, I need to be ... first line, underneath that is the person's name, then ...
    (microsoft.public.publisher)