Way to handle spouse without exporting?

[Jammer Six]

I need to write letters to a large number of people, who are all in
Entourage 2004.

I'd like to be able to handle the spouse's name without exporting to
Excel- every time we handle the data, bad things happen.

For instance, I'd like "Joe Smith" to become "Joe & Jill Smith" if
"Jill" is in the spouse's name.

Is there way to do this in Word and Entourage?

Thanks!

 

[Paul Berkowitz]

I need to write letters to a large number of people, who are all in
Entourage 2004.

I'd like to be able to handle the spouse's name without exporting to
Excel- every time we handle the data, bad things happen.

For instance, I'd like "Joe Smith" to become "Joe & Jill Smith" if
"Jill" is in the spouse's name.

Is there way to do this in Word and Entourage?

It could be done by an AppleScript that might take a long time to write.
Scripting the Entourage part would be easy. I have no idea how well mail
merges have been made scriptable by the new Word dictionary. (Since Data
Merge wasn't completed until Word X (it was rough and unfinished in 2001)
and Word VBA was more or less finished back in Word 98 and the new
AppleScript .) There is a lot in there for 'data merge' so it may well be
possible. But it looks awfully complicated. Maybe the new Reference will
help.

Or you could set permissions on the Excel file to Read Only and then no one
can mess with it. You could retain Read & Write for yourself if you wished.
All you have to do is select the file, do a Get Info (cmd-I) and set
permissions (under "Details") to Read Only for Group and Others. Keep
yourself as Owner - locked. You might perhaps need to set your own
permissions to Read Only too before sending copies or posting.

This seems a lot easier to me.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Jammer Six]

€ On 10/14/04 2:36 PM, in article 141020041436318791%[email protected],
€
€ > I need to write letters to a large number of people, who are all in
€ > Entourage 2004.
€ >
€ > I'd like to be able to handle the spouse's name without exporting to
€ > Excel- every time we handle the data, bad things happen.
€ >
€ > For instance, I'd like "Joe Smith" to become "Joe & Jill Smith" if
€ > "Jill" is in the spouse's name.
€ >
€ > Is there way to do this in Word and Entourage?
€
€ It could be done by an AppleScript that might take a long time to write.
€ Scripting the Entourage part would be easy.

No way to do it, then, inside either program?

Anyone?

 

[Matt Centurión [MSFT]]

€ On 10/14/04 2:36 PM, in article 141020041436318791%[email protected],
€
€ > I need to write letters to a large number of people, who are all in
€ > Entourage 2004.
€ >
€ > I'd like to be able to handle the spouse's name without exporting to
€ > Excel- every time we handle the data, bad things happen.
€ >
€ > For instance, I'd like "Joe Smith" to become "Joe & Jill Smith" if
€ > "Jill" is in the spouse's name.
€ >
€ > Is there way to do this in Word and Entourage?
€
€ It could be done by an AppleScript that might take a long time to write.
€ Scripting the Entourage part would be easy.

No way to do it, then, inside either program?

Anyone?

You can easily do this with an "IF" field. If you can't figure it out from
the online help, try the posting again here and I'm sure someone should be
able to help you out.

Matt
MacWord Testing
Macintosh Business Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this e-mail address. It is for
newsgroup purposes only.

Find out everything about Microsoft Mac Newsgroups at:
[http://www.microsoft.com/mac/community/community.aspx?pid=newsgroups]
Check out product updates and news & info at:
[http://www.microsoft.com/mac]

 

[Jammer Six]

€ On 10/18/04 2:16 PM, in article 181020041416265277%[email protected],
€
€ > In article <BD94A827.768E9%berkowit@spoof_silcom.com>, Paul Berkowitz
€ >
€ > € On 10/14/04 2:36 PM, in article 141020041436318791%[email protected],
€ > €
€ > € > I need to write letters to a large number of people, who are all in
€ > € > Entourage 2004.
€ > € >
€ > € > I'd like to be able to handle the spouse's name without exporting to
€ > € > Excel- every time we handle the data, bad things happen.
€ > € >
€ > € > For instance, I'd like "Joe Smith" to become "Joe & Jill Smith" if
€ > € > "Jill" is in the spouse's name.
€ > € >
€ > € > Is there way to do this in Word and Entourage?
€ > €
€ > € It could be done by an AppleScript that might take a long time to write.
€ > € Scripting the Entourage part would be easy.
€ >
€ > No way to do it, then, inside either program?
€ >
€ > Anyone?
€
€ You can easily do this with an "IF" field. If you can't figure it out from
€ the online help, try the posting again here and I'm sure someone should be
€ able to help you out.
€
€ Matt
€ MacWord Testing
€ Macintosh Business Unit


Well, Matt, I'm glad to hear that.

No, I can't figure it out, and apparently, neither can anyone else
here. The only answers I've received have involved exporting to Excel
or applescripts.

If you know how to do it, please tell me. The field "spouse" doesn't
show up in the Data Merge Manager when I create a form letter.

How do you do it?

Thanks!