[mso] Re: Word Merge

  • From: "Anne Robson" <anne.robson2@xxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Tue, 21 Oct 2003 15:27:12 +0100

Glenda

Try doing your search and replace with a space included after the
offending letters - ie:

Search for Po[space]
Replace with PO[space]

And make sure that your case sensitive box is ticked.

It *should* work - have done it plenty of times before but not on
something as large as your print run sounds.

Good luck!

Anne

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Glenda Wells
Sent: 21 October 2003 14:03
To: mso@xxxxxxxxxxxxx
Subject: [mso] Word Merge


Hi All.
We print tons'o'envelopes based on addresses we get from a database over
which we have little control.  We need to modify capitalization on the fly
for some of the most common errors.

For example
Po Box 1111 should be PO Box
121 Sw Some Street should be 121 SW Some Street

We checked with the folks who control the data and they say that the
sentence case auto thing they do to the data is a feature, not a bug...ha,
ha and the only other option we have at the source would be all caps which
is not what we want.

Short of an edit/replace kind of thing is there something we can put in
the merge fields that would help us with this annoying little issue?

Suggestions and advice appreciated. /g

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send
a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: