Merge to e-mail attachment problem

[LouALOH]

Word 2000 / Excel 2000

This one is really odd...
When we take this document and merge to printer or merge to another docment
it processes just fine.

However when we merge to an email attachment - part way through the job (100
rows or so) PART of the document is merging correctly, but a couple of
fields are getting data from the subsequent record !!

This is ONLY happening in merging to an attachment. And if we run the
individual row which seemed to cause the problem, it runs fine.
Removing the row also resolves the problem. However we have other rows which
create the problem again.

But we need to determine the cause because we cannot send thousands of
emails to try and "proof" the results. Yet that seems to be the only time
there is an issue.

Is there a way to see or save the word files being created as attachments?
Or merge to individual new documents?\

Any idea why it would skip to the next record to grab data but only in some
columns?

Who should I direct this to at Microsoft if I think it's a "bug" because in
my opinion, running it any way (print, new doc, e-mail attachment) should
yield consistent results and it surely does not....

Thank you

Lou

 

[Cindy M -WordMVP-]

Hi LouALOH,

Any idea why it would skip to the next record to grab data but only in some
columns?

Any chance that cells are empty in the rows where this is occurring? And are
you using a DDE connection (that would be the default).

I've heard of this happening (although not only to email) with Excel + DDE.
I'm not sure what the cause is, but often, going to a different connection
method resolves the problem.

Try activating the "Select method" checkbox in "Open data source", then choose
ODBC as the connection method. Run a test and see if the results are correct.
Note that you may see different number or date formatting (check for that!).
This would be a result of the connection method, and you'd need to add
formatting switches to the merge fields if this is happening.

Word 2000 / Excel 2000

This one is really odd...
When we take this document and merge to printer or merge to another docment
it processes just fine.

However when we merge to an email attachment - part way through the job (100
rows or so) PART of the document is merging correctly, but a couple of
fields are getting data from the subsequent record !!

This is ONLY happening in merging to an attachment. And if we run the
individual row which seemed to cause the problem, it runs fine.
Removing the row also resolves the problem. However we have other rows which
create the problem again.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail