Space Between Address And City.

[Sam]

Hi ...

Here is a message I posted in the word.VBA.beginners newsgroup. Cindy
Meister replied and told me to post it here, and to provide additional info.
Here's the original message I posted:

I am using Word 2000, Windows 98 SE.

The table has nine data fields.

APN Salut. Last First Adr1 Adr2 City State Zip

APN is a code number. Salut is Mr, Ms, etc. Use seven fields in the envelope
address I'm trying to print

<<First>> <<Last>>
<<Adr1>>
<<Adr2>>
<<City>>
<<State>> <<Zip>>

Sometimes Adr2 is blank, of course, but I have used this setup in the past
with no problem. Not from a table though, but from entering data in the Word
data entry feature. It looks just like a table, though. Yes, I made sure the
box `Do Not Print Blank Lines' was checked.

Thanks for any assistance.

Sam

A man who had lately declared
That property ought to be shared,
Thought it going too far
When they called for his car,
And a list of exceptions prepared.

Thomas Thorneley,
From The Penguin
Book Of Limericks

 

[Sam]

I looked at the text file, and it appears that data in the fields does not
always appear where it should. Sometimes it gets pushed one field to the
right.

It should look like this:
Jones Jim Ste. 100 233 3rd St. New York NY 10368

But sometimes, it looks like this:
Jones Jim Ste. 100 233 3rd St. New York NY 10368

Is this what Word means when it says there are too few data fields?? Looks
to me like there are plenty of data fields. I guess the Zip field doesn't
exist to Word. It must think that Adr2 and City are now the same field. (I
am just speculating - I really have no idea.)

Sam

 

[Sam]

Have been working on this problem for several hours, and I am no closer
to figuring it out. Would really appreciate any help. I have tried to copy
the table to a Excel worksheet and use mail merge from there, but I get
message, `Could not establish DDE Connection with Excel.'

I have saved the Word document in different formats. Text, Text w/line
breaks etc. etc. etc. I have re-converted the table back to text. Nothing
seems to work.

Thanks for any help.

Sam

 

[Peter Jamieson]

as the data source. This time when I tried to Mail Merge, a window
popped up
It usually means that the header containing the field names suggests that
there should be a certain number of fields (let's say 6) in each record, but
when Word examines the data records it finds a different number of fields in
one or more records, say 7.

However, considering that you have used Word's data entry feature and are
(apparently) storing your data ina table in a Word document, you should not
experience this problem

It looks just like a table, though.

Can you confirm/deny that this means that if you open the data source
document, it is (or at least looks like) a Word .doc and contains a Word
table with 9 columns? Or is it another format (e.g. a .doc with
tab-delimited records, or a .txt file)?