[Mommab]

We just updated to Office 2007 and I have an envelope mail merge that I use
each week. I have a macro that changes the data that is merged from small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the envelopes,
Word changes them back to their original Upper and lower case format. What
do I need to do to make the macro stick and print in all caps. Also, I have
to go into each envelope to use the macro, which is a pain. Is there a way
to effect a change on all the documents at once? Thanks for any help you can
give me!

[Peter Jamieson]

1. What does your macro work with, exactly, i.e. exactly what data does it
change, where, and at what point in the process?

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the periods,
of course)

Peter Jamieson

"Mommab" wrote in message
...
We just updated to Office 2007 and I have an envelope mail merge that I
use
each week. I have a macro that changes the data that is merged from small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the
envelopes,
Word changes them back to their original Upper and lower case format.
What
do I need to do to make the macro stick and print in all caps. Also, I
have
to go into each envelope to use the macro, which is a pain. Is there a
way
to effect a change on all the documents at once? Thanks for any help you
can
give me!

[Mommab]

No, how do you do that?

"Peter Jamieson" wrote:

1. What does your macro work with, exactly, i.e. exactly what data does it
change, where, and at what point in the process?

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the periods,
of course)

Peter Jamieson

"Mommab" wrote in message
...
We just updated to Office 2007 and I have an envelope mail merge that I
use
each week. I have a macro that changes the data that is merged from small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the
envelopes,
Word changes them back to their original Upper and lower case format.
What
do I need to do to make the macro stick and print in all caps. Also, I
have
to go into each envelope to use the macro, which is a pain. Is there a
way
to effect a change on all the documents at once? Thanks for any help you
can
give me!

[Peter Jamieson]

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the
periods,
of course)

Use Alt-F9 to display the underlying field codes, and where you have, for
example

{ MERGEFIELD xyz }

change it to

{ MERGEFIELD xyz \*Caps }

(you can do this for field types other than MERGEFIELD but I don't kow if it
works for things like ADDRESSBLOCK. And it won't get rid of the periods)

Peter Jamieson

"Mommab" wrote in message
...
No, how do you do that?

"Peter Jamieson" wrote:

1. What does your macro work with, exactly, i.e. exactly what data does
it
change, where, and at what point in the process?

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the
periods,
of course)

Peter Jamieson

"Mommab" wrote in message
...
We just updated to Office 2007 and I have an envelope mail merge that I
use
each week. I have a macro that changes the data that is merged from
small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the
envelopes,
Word changes them back to their original Upper and lower case format.
What
do I need to do to make the macro stick and print in all caps. Also, I
have
to go into each envelope to use the macro, which is a pain. Is there a
way
to effect a change on all the documents at once? Thanks for any help
you
can
give me!

[Mommab]

Thank you Peter, I appreciate your help. I have a lot to learn in these new
programs. ;-)

"Peter Jamieson" wrote:

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the
periods,
of course)

Use Alt-F9 to display the underlying field codes, and where you have, for
example

{ MERGEFIELD xyz }

change it to

{ MERGEFIELD xyz \*Caps }

(you can do this for field types other than MERGEFIELD but I don't kow if it
works for things like ADDRESSBLOCK. And it won't get rid of the periods)

Peter Jamieson

"Mommab" wrote in message
...
No, how do you do that?

"Peter Jamieson" wrote:

1. What does your macro work with, exactly, i.e. exactly what data does
it
change, where, and at what point in the process?

2. Have you considered changing your envelope layout so that the relevant
mergefields have \*Caps switches in them? (That won't deal with the
periods,
of course)

Peter Jamieson

"Mommab" wrote in message
...
We just updated to Office 2007 and I have an envelope mail merge that I
use
each week. I have a macro that changes the data that is merged from
small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the
envelopes,
Word changes them back to their original Upper and lower case format.
What
do I need to do to make the macro stick and print in all caps. Also, I
have
to go into each envelope to use the macro, which is a pain. Is there a
way
to effect a change on all the documents at once? Thanks for any help
you
can
give me!