Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cc frosh - 24 Mar 2006 03:13 GMT

I am trying to do Mail Merge letters from Excel into Word, but some of the
cells in Excel will be calculated fields with formulas. I want Word to bring
in the results of the calculation, not the formula in the cell and the format
(cell is formatted as currency, but Word brings in just the number. I am
fairly new to Word, have always used Word Perfect in the past. Any help on
this would be greatly appreciated. I also have to bring in percentages (like
44.4%) but to get this merged in correctly I have to make the cell "Text",
but I need to have it as percent because it is part of my calculations
mentioned above. If you can't help me, then maybe you can tell where to go
or look or what book to purchase to help me with this. Thanks -- CC Frosh

Reply to this Message

Doug Robbins - Word MVP - 24 Mar 2006 06:03 GMT

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

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to do Mail Merge letters from Excel into Word, but some of the
> cells in Excel will be calculated fields with formulas. I want Word to
[quoted text clipped - 11 lines]
> go
> or look or what book to purchase to help me with this. Thanks -- CC Frosh

Reply to this Message

Graham Mayor - 24 Mar 2006 06:48 GMT

See http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> I am trying to do Mail Merge letters from Excel into Word, but some
> of the cells in Excel will be calculated fields with formulas. I
[quoted text clipped - 8 lines]
> can tell where to go or look or what book to purchase to help me with
> this. Thanks -- CC Frosh

Reply to this Message

Dale - 25 Mar 2006 01:14 GMT

> I am trying to do Mail Merge letters from Excel into Word, but some of the
> cells in Excel will be calculated fields with formulas. I want Word to bring
[quoted text clipped - 6 lines]
> mentioned above. If you can't help me, then maybe you can tell where to go
> or look or what book to purchase to help me with this. Thanks -- CC Frosh

If I could make a suggestion, try to find Word and Excel 2000. I have
tried using the instructions posted, but have found it extremely
difficult to make merging work correctly. Our secretary uses Office XP
and has to send files to me, where I open them up in 2000 and do the
merging. The first part of the site of Graham Mayor that says,

"The interface has been completely redesigned, and simple functions have
been replaced with unnecessary complexity.'

really says it all.

Reply to this Message