A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Insert field codes into equations



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 05:04 AM posted to microsoft.public.word.mailmerge.fields
Ted S
external usenet poster
 
Posts: 3
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  
Old March 19th, 2010, 08:24 PM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.