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

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 ToolsOptions, 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/as...164951033.aspx


kbreiss wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote

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 ToolsOptions, 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/as...164951033.aspx


kbreiss wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

kbreiss wrote:
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" wrote


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 ToolsOptions, 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/as...164951033.aspx


kbreiss wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html