Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Jacqui Jacqui is offline
external usenet poster
 
Posts: 23
Default Field Calculation Error in Mailmerge

I have a very simple mailmerge which consists of a letter and date
from a word table. There are only two fields, one of the address and
one for the salutation. When I do the merge I get a message saying '
field calculation error in record no. #' The merge works okay, but
this message appears for every record.

I googled and found a few topics on this but nothing relevant to me,
ie I am not using any IF or ASK fields. I recreated the data to test,
into excel and made a field for name, add1 etc and that produced the
same result which leads me to believe the problem is with my letter
template. The only other fields in this are some form text fields and
a create date field. I have used this letter template for many
mailmerges in the past and have not had this problem. Can anyone help?
  #2   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Jacqui Jacqui is offline
external usenet poster
 
Posts: 23
Default Field Calculation Error in Mailmerge

On Apr 18, 9:54*am, Jacqui
wrote:
I have a very simple mailmerge which consists of a letter and date
from a word table. There are only two fields, one of the address and
one for the salutation. *When I do the merge I get a message saying '
field calculation error in record no. #' The merge works okay, but
this message appears for every record.

I googled and found a few topics on this but nothing relevant to me,
ie I am not using any IF or ASK fields. *I recreated the data to test,
into excel and made a field for name, add1 etc and that produced the
same result which leads me to believe the problem is with my letter
template. *The only other fields in this are some form text fields and
a create date field. * I have used this letter template for many
mailmerges in the past and have not had this problem. *Can anyone help?


I found the solution: If my letter goes to a second page there's a
STYLEREF field on page two which picks up the recipent name. In this
case the merge doesn't use the recipient name style in the address
block and as the letter was not a two page it didn't seem important,
obviously the merge process was looking for this field however.
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
Field calculation error using calculated dates IPandA Mailmerge 0 January 7th 08 11:44 PM
field calculation error message Eloy Mailmerge 6 September 27th 06 05:27 PM
Field Calculation Error Frank Mailmerge 1 July 18th 06 04:40 AM
Calculation field error moombi Tables 0 June 9th 05 01:40 PM
field calculation error, mailmerge, Cindy M -WordMVP- Mailmerge 0 November 30th 04 05:25 PM


All times are GMT +1. The time now is 05:55 PM.

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

About Us

"It's about Microsoft Word"