Re: Mail merged document changed values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In that case you are going to have to change the data file to use separate
fields for the numbers and letters. The numbers can be tamed with a
formatting switch {Mergefield fieldname \# "0"}{Mergefield letterfield}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

tlc_tgo wrote:
Dear Mr. Mayor,

Thank you for your suggestion, but alas, it is not sufficient. Using
the DDE method did correct the problem with my customer IDs, but it
also altered the names and addresses of my customers. Many of the
names in my customer list -- particularly those from Eastern Europe
use inflections and other diacritical marks on the standard latin
alphabet. DDE either changes these letters to a base latin
character or gives up and replaces it with a question mark. I need
to spell my customer's names and addresses correctly and not use some
English language equivalent.

The OLE method causes the previously mentioned zero replacement for
the customer ID, while the ODBC method converts the customer ID to
decimals (e.g. 123456 becomes 123456.0)

Got any other ideas?
Thanks, tlc_tgo.


"Graham Mayor" wrote:

From the Tools menu in Word, select Options and then go to the
General tab and check the box against the "Confirm conversions at
open" item. Then when you attach the data source to the mail merge
main document, you will be given the option of using the DDE method
of connection which should read the data as you have it formatted in
the table.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

tlc_tgo wrote:
I'm having a related problem in Office 2003 SP2. In my case,
numeric customer IDs are translated to a zero. I keep a list of
customer contacts in an EXCEL spreadsheet, including a column of
customer IDs that are usually a six digit numeric code. However,
those customers that have a related site I append a character to
the end of their Id. For example if the primary site ID is 123456
then related site ID will be 123456A. When I use mail merge to
create a form letter that includes the customer ID, the six-digit
numeric codes print fine, but the related site IDs appear as a
single zero.

I re-examined the formatting in my customer spreadsheet and realized
that the Customer ID column was formatted as "number". Aha! I said
to myself and changed it to "text". I saved the spreadsheet,
re-opened my word template, refreshed the connection to the
spreadsheet, and re-ran the merge. 123456A still was displayed as a
zero. I tried inserting a space before each ID. No effect.
Finally, inserted a non-blank character before the ID. That worked,
but now I have a dorky-looking apostrophe in my printed customer
IDs.

Any ideas for a better work around?
-- Thanks


"KYaeger" wrote:

I have a word letter with merged fields from Access. One field
containing salary sometimes is not what is stored in the Access
table. e.g. employees salary in employees table is $927.20. In
the merged document it is listed as $929.00-even rounded it would
not be that. If I remove the field code for currency formatting
it will appear as 927.2. In most cases the merged field is
correct, but occassionally this problem will come up. I have
tried re-entering it in the table, but still wrong in the
document. We should be able to rely on correct information as
there are no calculations, only straight merging form one table.
This is Word2003 and Access 2003. Thoughts?


.

Relevant Pages

  • Re: Fun With AT&T
    ... I am trying to order new telephone service via your web site. ... If this response does not address your concern, ... Your AT&T Customer Service Representative ... Make sure to close all Internet Explorer windows ...
    (misc.consumers)
  • Re: Fun With AT&T
    ... I am trying to order new telephone service via your web site. ... If this response does not address your concern, ... Your AT&T Customer Service Representative ... Make sure to close all Internet Explorer windows ...
    (misc.consumers)
  • Re: Combine INCLUDEPICTURE with variable?
    ... Word MVP web site http://word.mvps.org ... Dim pRange As Word.Range ... For Each pRange In ActiveDocument.StoryRanges ... 'Next line is added so customer logo will be updated ...
    (microsoft.public.word.vba.userforms)
  • Re: Learn How VoiceMax Increases Your Transmission Range...
    ... How about some feedback from a customer after they have ... We keep our shoes on and leave our brains at the door. ... Tell that to Web site designers. ... I wonder if Brian has considered whether another speech processor ...
    (rec.radio.cb)
  • Re: Contract law - new contract terms imposed unilaterally
    ... What I'm saying is that the chances of the customer not having ... court, and even less likely to be convincing in court if for some odd ... Of course there may be good reasons, no one is arguing against that. ... Only the correct two of the four letters were referred to by the ...
    (uk.legal)