I have a mail merge document containing the following:

{ IF { MERGEFIELD ExpirationDate } "" { IF { MERGEFIELD ExpirationDate \@
"yyyyMMdd" } { DATE \@ "yyyyMMdd" } "Your insurance expired on {
MERGEFIELD ExpirationDate }.Enter
" "{ IF { MERGEFIELD Amount } "" "Your insurance limit is { MERGEFIELD
Amount }.Enter
" }}}

where Enter is hitting the "Enter" key.

My data source contains an ExpirationDate less than the current date, e.g.
1/1/2006.

When I merge the data into a Word document, everything works fine and the
document contains "Your insurance expired on 1/1/2006".

When I merge the data into an eMail message, the following text is in the
message: "Your insurance expired on ExpirationDate."

I have removed and reentered the ExpirationDate merge field and the results
stay the same.

Does anyone have any suggestions about what I can do to resolve this
problem?

Thanks,
Tom

I see the same thing here, but only when I merge to HTML format.

Using e.g.

{ SET LExpDate { MERGEFIELD ExpirationDate } }{ IF { MERGEFIELD
ExpirationDate } "" { IF { MERGEFIELD ExpirationDate \@
"yyyyMMdd" } { DATE \@ "yyyyMMdd" } "Your insurance expired on {
LExpDate }
..Enter
" "{ IF { MERGEFIELD Amount } "" "Your insurance limit is { MERGEFIELD
Amount }.Enter
" }}}

works OK here.

Peter Jamieson

"Tom Bean" wrote in message
...
I have a mail merge document containing the following:

{ IF { MERGEFIELD ExpirationDate } "" { IF { MERGEFIELD ExpirationDate
\@ "yyyyMMdd" } { DATE \@ "yyyyMMdd" } "Your insurance expired on {
MERGEFIELD ExpirationDate }.Enter
" "{ IF { MERGEFIELD Amount } "" "Your insurance limit is { MERGEFIELD
Amount }.Enter
" }}}

where Enter is hitting the "Enter" key.

My data source contains an ExpirationDate less than the current date, e.g.
1/1/2006.

When I merge the data into a Word document, everything works fine and the
document contains "Your insurance expired on 1/1/2006".

When I merge the data into an eMail message, the following text is in the
message: "Your insurance expired on ExpirationDate."

I have removed and reentered the ExpirationDate merge field and the
results stay the same.

Does anyone have any suggestions about what I can do to resolve this
problem?

Thanks,
Tom

Peter,

I implemented you suggestion and the "SET" solved the problem with the
eMail.

Thanks very much,
Tom

"Peter Jamieson" wrote in message
...
I see the same thing here, but only when I merge to HTML format.

Using e.g.

{ SET LExpDate { MERGEFIELD ExpirationDate } }{ IF { MERGEFIELD
ExpirationDate } "" { IF { MERGEFIELD ExpirationDate \@
"yyyyMMdd" } { DATE \@ "yyyyMMdd" } "Your insurance expired on {
LExpDate }
.Enter
" "{ IF { MERGEFIELD Amount } "" "Your insurance limit is { MERGEFIELD
Amount }.Enter
" }}}

works OK here.

Peter Jamieson

"Tom Bean" wrote in message
...
I have a mail merge document containing the following:

{ IF { MERGEFIELD ExpirationDate } "" { IF { MERGEFIELD ExpirationDate
\@ "yyyyMMdd" } { DATE \@ "yyyyMMdd" } "Your insurance expired on {
MERGEFIELD ExpirationDate }.Enter
" "{ IF { MERGEFIELD Amount } "" "Your insurance limit is { MERGEFIELD
Amount }.Enter
" }}}

where Enter is hitting the "Enter" key.

My data source contains an ExpirationDate less than the current date,
e.g. 1/1/2006.

When I merge the data into a Word document, everything works fine and the
document contains "Your insurance expired on 1/1/2006".

When I merge the data into an eMail message, the following text is in the
message: "Your insurance expired on ExpirationDate."

I have removed and reentered the ExpirationDate merge field and the
results stay the same.

Does anyone have any suggestions about what I can do to resolve this
problem?

Thanks,
Tom