[mso] Re: Word Merge

  • From: "Glenda Wells" <gwells@xxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Tue, 21 Oct 2003 10:51:50 -0400

Thanks Ann.

We do the search/replace thing all the time.  We're just looking for a
more programmed way to get the job done.  We could build a macro based
on our search/replace procedure but I'm wondering if there's something
we could include in the merge field itself or if there's another way.

/g

-----Original Message-----
From: Anne Robson [mailto:anne.robson2@xxxxxxxxxxxxxx]=20
Sent: Tuesday, October 21, 2003 10:27 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word Merge


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=20
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
*************************************************************
*************************************************************
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: