Passing text fields from Excel

[charles_weaver]

I am trying to copy my Excel gradebook into Word documents with
mailmerge. I found that I had to take the data through a converter to
get it to format the percentages in my spread sheet correctly. When I
use ODBBC it gives millions of decimal places and when I use DDE it
mixes up some fields. I decided to use the converter because that
worked the best. Then I added a field that contains the letter grade
which is generated by a VB function as text. The text does not show up
in the Word document. It just appears as an underline. When I tried
earlier to display text cells that I read from another cell in the
spreadsheet it had the same problem.

What am I missing? I feel like I can't win.


I am using Office XP SP1 and Windows Home XP SP2.

 

[Doug Robbins]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[charles_weaver]

Thanks for the reference. I found it in a previous note, possibly from
you. I tried to use DDE and it seemed that it was switching some of the
fields - maybe I had them named badly. I am using the "via converter"
option and it seems to work fine for numeric fields and ones where text
has been typed in. The fields where I linked to a text field or used a
VBA macro to generate it do not appear at all. If I use ODBC they
appear fine but then the floating point fields have millions of decimal
places and I can't control it. I finally just typed the generated text
fields (letter grades) by hand in the output.