Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

mail/merge using Word 2007

Feb 7, 2011 11:01PM PST

i'm creating labels using an excel file as input. What I would like to do is to have 2 of the fields; first name & last name appear on the lable in CAPITAL letters. I build the first label, then highlight the name fields and use the change case option and select "UPPERCASE". when I select the "preview results" option, the fields remain unchanged. am I missing something? I am a novice at mail/merge but this one seems like it should be easy to resolve. thanks.

Discussion is locked

- Collapse -
What happens if you run it ...
Feb 7, 2011 11:12PM PST

instead of previewing it. Also lower case?

Kees

- Collapse -
run it?
Feb 7, 2011 11:29PM PST

not sure what you mean. I have gone to the finish & merge option and selected "edit individual documents" to create a new word doc with the labels but they're still lower case and I would have to select and change each label manually. I have been able to resolve this problem on another version of Word so I'm wondering if this is a 2007 issue.

- Collapse -
If it stays lowercase ...
Feb 8, 2011 5:03AM PST

not only in the preview, but also in the actual output, I'd use the classic trick. That's doing it in Excel. Add a column with the upshifted firstname; add a column with the upshifted last name. That's the UPPER function. Then use that columns in your mail merge in stead of the original one.

Don't care about advanced mail merge functions if they are so easy to circumvent.

Kees

- Collapse -
i've relented
Feb 15, 2011 10:50PM PST

thanks Kees, that was my fallback plan which I've ended up doing rather than bang my head against the wall. prep the data in Excell before the merge.

- Collapse -
Just so you know.
Feb 7, 2011 11:30PM PST

Mailmerge and little things to outright gaffes are legendary. If you need mailmerge to be perfect you learn that you either accept what it does or code up your own or go buy a better one.
Bob