Mailmerge with "If" statement producing unexpected results

[Griffo]

Hi there

I'm using the below code for my mail merge.

Problem is that when there is a "/" in the Street1 or Street2 fields, I get
a bunch of characters on that line that shouldn't be there.

Can anyone shed any light as to what might be going wrong - I built this
statement by looking around on the net - I'm very much a novice when it comes
to this stuff.

If it is relevant, I'm using Word 2003 with the data being pulled from an
Excel 2003 spreadsheet.

Thanks
Griffo

 

[Griffo]

Hi there

I'm using the below code for my mail merge.

Problem is that when there is a "/" in the Street1 or Street2 fields, I get
a bunch of characters on that line that shouldn't be there.

Can anyone shed any light as to what might be going wrong - I built this
statement by looking around on the net - I'm very much a novice when it comes
to this stuff.

If it is relevant, I'm using Word 2003 with the data being pulled from an
Excel 2003 spreadsheet.

EDIT - here is the code!

{ if { MERGEFIELD "ShipToName" } = "same as billing" "{ADDRESSBLOCK \F"
"{MERGEFIELD "ShipToName" \* UPPER }
{ MERGEFIELD "ShipToAddress1" \* UPPER }
{ MERGEFIELD "ShipToAddress2" \* UPPER }
{ MERGEFIELD "ShipToCity" \* UPPER } { MERGEFIELD "ShipToState" \* UPPER }
{ MERGEFIELD "ShipToPostalCode" }"}

 

[Doug Robbins - Word MVP on news.microsoft.com]

Try doing it without using the AddressBlock field. Instead, just insert the
actual mergefields in the configuration that you want them.

--
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, originally posted via msnews.microsoft.com