capitalization in word of access data via mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

harvey - 11 Sep 2005 14:40 GMT

I use word 2000 and access 2000. In access, I create all caps by using > in
the format section of my table. When I merge labels in word using the mail
merge feature, with access data as the source, the labels come out lower or
initial case.

Q. The result I want is for fields [firstlast], [address], and [city state]
when I print in word via mail merge to come out as all caps.

I am not familiar with vba, basic or other programming language.
Guidance would be greatly appreciated.

Reply to this Message

Doug Robbins - 11 Sep 2005 22:04 GMT

Use Alt+F9 to toggle on the display of the field codes and add the \*
Charformat switch to the mergefields and format the m of Mailmerge (using
Format>Font) to be All Capitals.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I use word 2000 and access 2000. In access, I create all caps by using >
>in
[quoted text clipped - 10 lines]
> I am not familiar with vba, basic or other programming language.
> Guidance would be greatly appreciated.

Reply to this Message