Value of formula field

[kbreiss]

I have a formula...LEFT(D2,FIND(",",D2,1)-1)
Basically it takes Civic Memorial Field, Somwhere, NV
and gives me only Civic Memorial Field.

However when I use this field in a mail merge using word it only recognizes
the number of spaces.

Is there anyway to add a funcion on my formula to return the actual value.
If I do a copy and paste special value it works correctly in the mail merge
but w/ this method everytime I change the document I would have to recopy and
paste special again. Hopefully I haven't confused anyone too much. Thanks
in advance,

Kreiss

 

[Debra Dalgleish]

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

There's an article on the Microsoft web site that gives a bit more
information:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

 

[kbreiss]

When I attempt using MS Excel Worksheets via DDE I get a "Word could not
re-establish a DDE connection to Microsoft Excel to complete the current
task" error...therefore to get the mailmerge to work I have to use the
"Microsoft Excel Worksheet Converter", but when I use this it doesn't
recognize my Excel fieds that are created by a formula...do you have any
other suggestions to get the formula fieds to work in the Word Mail Merge?
Thanks for the response.

Thanks again,
Kacy

 

[Debra Dalgleish]

Try using an OLE DB connection instead.

If that doesn't work, then you may have to copy the text formula, and
paste it as values into an additional column in the source table.