Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
weird macro thing in Word 2007
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
weird macro thing in Word 2007
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! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
weird macro thing in Word 2007
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! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
weird macro thing in Word 2007
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! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
weird macro thing in Word 2007
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 macro command buttons on toolbar | Microsoft Word Help | |||
Word 2007 - caption - weird number behaviour | Tables | |||
Word 2007 macro button icons | Microsoft Word Help | |||
Macro toolbars in word 2007 | Microsoft Word Help | |||
Weird Behaviour : Track Changes Adds Weird Text While Document is Protected | Microsoft Word Help |