|
|
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!
|
|
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" <Mommab[ at ]discussions.microsoft.com> wrote in message
news:1BE30889-571B-4FFD-9766-E1E4321E8221[ at ]microsoft.com...
[Quoted Text] > 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!
|
|
No, how do you do that?
"Peter Jamieson" wrote:
[Quoted Text] > 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" <Mommab[ at ]discussions.microsoft.com> wrote in message
> news:1BE30889-571B-4FFD-9766-E1E4321E8221[ at ]microsoft.com...
> > 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!
>
>
|
|
|
[Quoted Text] >> 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" <Mommab[ at ]discussions.microsoft.com> wrote in message
news:B751143F-FE9C-4F11-954D-BF87C241B426[ at ]microsoft.com...
> 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" <Mommab[ at ]discussions.microsoft.com> wrote in message
>> news:1BE30889-571B-4FFD-9766-E1E4321E8221[ at ]microsoft.com...
>> > 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!
>>
>>
|
|
Thank you Peter, I appreciate your help. I have a lot to learn in these new
programs. ;-)
"Peter Jamieson" wrote:
[Quoted Text] > >> 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" <Mommab[ at ]discussions.microsoft.com> wrote in message
> news:B751143F-FE9C-4F11-954D-BF87C241B426[ at ]microsoft.com...
> > 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" <Mommab[ at ]discussions.microsoft.com> wrote in message
> >> news:1BE30889-571B-4FFD-9766-E1E4321E8221[ at ]microsoft.com...
> >> > 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!
> >>
> >>
>
>
|
|
|