Fields in ZIP Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenny - 22 Jan 2006 03:29 GMT

How do I remove a 'space' character from the start of my UK Postal codes in
mailmerge using Office XP? I created a new list of recipients. I changed the
words ZIP code to Postcode by renaming the field. Everything looks OK until I
merge the document. The UK Postcode looks like *BD2 2AH on the document and
it should look like BD2 2AH. The * is the space character.

Any advice would be welcome.

Reply to this Message

Graham Mayor - 22 Jan 2006 06:18 GMT

Where is the data coming from?
There are only two ways you can get a space here.
1. It's in the data.
2. You have inserted a space in front of the field.
However your earlier post seems to suggest you are using the AddressBlock
field. Don't! Use the individual fields. Incidentally it doesn't matter
whether the field is called Zip or PostCode. It's what it contains that is
important.
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and
http://www.gmayor.com/formatting_word_fields.htm may help.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do I remove a 'space' character from the start of my UK Postal
> codes in mailmerge using Office XP? I created a new list of
[quoted text clipped - 4 lines]
>
> Any advice would be welcome.

Reply to this Message

macropod - 22 Jan 2006 07:31 GMT

Hi Jenny,

You can't do that in the mailmerge document - you'll need to change the
source.

Cheers

> How do I remove a 'space' character from the start of my UK Postal codes in
> mailmerge using Office XP? I created a new list of recipients. I changed the
[quoted text clipped - 3 lines]
>
> Any advice would be welcome.

Reply to this Message