weird macro thing in Word 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mommab - 12 Jun 2007 18:03 GMT

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!

Reply to this Message

Peter Jamieson - 12 Jun 2007 19:01 GMT

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

> We just updated to Office 2007 and I have an envelope mail merge that I
> use
[quoted text clipped - 11 lines]
> can
> give me!

Reply to this Message

Mommab - 12 Jun 2007 21:52 GMT

No, how do you do that?

> 1. What does your macro work with, exactly, i.e. exactly what data does it
> change, where, and at what point in the process?
[quoted text clipped - 20 lines]
> > can
> > give me!

Reply to this Message

Peter Jamieson - 13 Jun 2007 01:27 GMT

>> 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

> No, how do you do that?
>
[quoted text clipped - 26 lines]
>> > can
>> > give me!

Reply to this Message

Mommab - 13 Jun 2007 15:49 GMT

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

> >> 2. Have you considered changing your envelope layout so that the relevant
> >> mergefields have \*Caps switches in them? (That won't deal with the
[quoted text clipped - 45 lines]
> >> > can
> >> > give me!

Reply to this Message

Rate this thread: