Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ted S Ted S is offline
external usenet poster
 
Posts: 1
Default Insert field codes into equations

I'm a teacher trying to merge data from a spreadsheet (this data is actually
numerical answers to test questions) into a word document equation.

When I insert the field codes into the equation, they initially work when I
preview the results, but then what got merged can never be updated - actually
the field codes are gone after one preview but the original data imported is
permanent text.

This problem only occurs with field codes in formulas, all other data is
imported just fine.

I know that this may be a use of the mail merge feature that was not
originally envisioned, but is there some setting/option that can fix this
problem?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Insert field codes into equations

Hi Ted,

Mergefields, per se, never survive a mailmerge - by design you only ever get the field results.

As for the specifics of your query, do you mean an Equation (EQ) field or a Formula (eg '=' or IF) field?

If it's the latter, any IF field tests in mailmerges are always converted to their results - the part(s) of a formula outside the IF
test(s) with the largest scope will remain as a field, though. Depending on what you're doing, it may be possible to re-cast the
formula without the IF tests. If you care to post the field coding here, I'd be happy to take a look at it and suggest any changes
that you might be able to make along those lines.

--
Cheers
macropod
[Microsoft MVP - Word]


"Ted S" Ted wrote in message ...
I'm a teacher trying to merge data from a spreadsheet (this data is actually
numerical answers to test questions) into a word document equation.

When I insert the field codes into the equation, they initially work when I
preview the results, but then what got merged can never be updated - actually
the field codes are gone after one preview but the original data imported is
permanent text.

This problem only occurs with field codes in formulas, all other data is
imported just fine.

I know that this may be a use of the mail merge feature that was not
originally envisioned, but is there some setting/option that can fix this
problem?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Auto Field Codes JD Microsoft Word Help 2 July 22nd 09 06:19 PM
Ignore merge field codes when field doesn't exist mcalex Mailmerge 2 October 29th 08 08:56 AM
Saving word document with field results not field codes Cambdoc Microsoft Word Help 2 July 14th 06 10:51 AM
How to use field codes to insert addressee name in pg 2 header? Virginia Microsoft Word Help 5 March 15th 06 11:55 PM
Can I insert a conditional page break using field codes? Risseecm Mailmerge 7 April 13th 05 11:51 AM


All times are GMT +1. The time now is 11:04 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"