Re: Can I merge labels in Word, Office X?

I'll read the link. I quickly made your suggestions, eliminating the commas,
etc. Still got the error when choosing the xls file as the data source.

Thanks for the help (and I'll watch the split subject in the future. I got no
response at first so I tried a second post. Sorry)

In article <C3057BBD.2AB31%onlygeneraltaz1@xxxxxxxxxxxx>,
CyberTaz <onlygeneraltaz1@xxxxxxxxxxxx> wrote:

I think Word may be having trouble recognizing the combination of tabs &
commas in the text file as to what constitutes a "field"... Both are used as
field delimiters & the combination creates havoc. You could take the time to
put quotation marks around the content of each field ("Smith, Joe","2 Elm
St.","Boston, MA") but...

I'd suggest setting your data source up in Excel. Further, put each data
item in a separate field (column) so you'd have:

LastName FirstName Address City State (Zip)?

That will give you much more flexibility in sorting, record selection, data
placement/arrangement, etc. Just start in cell A1 with no separation between
columns & in consecutive rows beginning with the field names.

Follow the model you'll find here:

http://www.microsoft.com/mac/products/word2004/using.aspx?pid=usingword2004&;
type=howto&article=/mac/LIBRARY/how_to_articles/officex/wd_catalog.xml#Excel
X

(assuming the long link doesn't break:-))

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 9/5/07 8:00 PM, in article
spamhwaxman-3A3A3F.20002905092007@xxxxxxxxxxxxxxxxxxxx, "Harvey Waxman"
<spamhwaxman@xxxxxxx> wrote:

thanks for offering to help.

My data source looks like this:

name <tab> address <tab> city <cr>
Smith, Joe <tab> 1 Main St. <tab> Boston, MA <cr>

etc. Saved as a text file

1. Open blank document in Word
2. Data Merge Manager > Create > labels choose the appropriate label
from
the list.
3. Document shows the labels as chosen
4. Data Merge Manager > Data Source browse to and select above file
5. This is when Word freezes and I have to force quite. (Spinning rainbow
wheel)


In article <#sTbpp$7HHA.4880@xxxxxxxxxxxxxxxxxxxx>,
"CyberTaz" <typegeneraltaz1ATcomcastdotnet> wrote:

Labels should not be a problem if the record source ("data file") is set
up
correctly. What concerns me - and it may simply be a matter of semantics,
but a very important one - is your use of the terms "open" and "importing"
relevant to your data file. Technically you should do *neither* - the
label
doc gets linked or connected to the record source, but you don't actually
open the data file in Word to do the merge.

Please provide specific detail on how you are attempting to do the merge -
steb-by-step - if these articles don't resolve the issue for you.





--
Harvey Waxman
remove spam to email
http://righttax.org/
.

Relevant Pages

  • Re: Word2000 mailmerge message
    ... Changed de commas into points: ... "Peter Jamieson" wrote: ... the fields are in the datafile itself (the field separator is: ... Do you have a separate "header data source" that just contains ...
    (microsoft.public.word.mailmerge.fields)
  • Re: text file for mail merge stumped
    ... Doug Robbins - Word MVP ... Here is my last attempt at macro recording. ... "entries" separated by commas, running the following code will convert ... mail merge data source. ...
    (microsoft.public.word.vba.beginners)
  • Re: text file for mail merge
    ... replace it with ^p to get rid of the superfluous commas where there is ... My recommendation was to open that file in Word and use a macro ... in which format the data can be used as a data source. ... When I run it stops on delimiter screen. ...
    (microsoft.public.word.vba.beginners)
  • Re: Line breaks
    ... If I replace the commas with something else e.g: ... and use that as the data source for your merge. ... has problems because you will not be able to connect to that query using ... I assume there is a special character I need to insert in the address field ...
    (microsoft.public.word.mailmerge.fields)
  • Re: text file for mail merge
    ... Doug Robbins - Word MVP ... replace it with ^p to get rid of the superfluous commas where there is ... My recommendation was to open that file in Word and use a macro ... in which format the data can be used as a data source. ...
    (microsoft.public.word.vba.beginners)
Loading