Mail Merge – Word and Access

Topic

New Reply

I am using an Access database where for several of the fields I I have enterred data in lowercase however I have set the fields’ format to < (UPPERCASE). When I do a mail merge these fields revert to lowerecase. How do I maintain the fields in UPPERCASE after merge? Thanks!!

Reply | Quote

Replies

A few things …

Using as a format in Access does NOT change the actual stored text – just how it is displayed in Access.

So you could base the mail merge on a query that converts the text to Upper Case using the StrConv function.

So say you had a field called Town in Access that was lowercase. In the query you would do this:

City: StrConv([Town], vbUpperCase). Then use the field City in the merge.

This does not change what is actually stored in Access.

Another option is to run an Update query in Access that actually changes the stored data in Access.

Reply | Quote

I am using an Access database where for several of the fields I I have enterred data in lowercase however I have set the fields’ format to < (UPPERCASE). When I do a mail merge these fields revert to lowerecase. How do I maintain the fields in UPPERCASE after merge? Thanks!!

Hi bbrown5,

The easiest way to fix this is to modify the mergefield(s) in Word. That way, you don't need to make any changes to the database.

In Word:
1. Select the problem mergefield (eg «MyField») and press Shift-F9. You should now see {MERGEFIELD MyField}
2. Edit the field code by adding a formatting switchm, thus: {MERGEFIELD MyField * Upper}
3. Press F9 to update the field
4. Repeat steps 1-3 for each problem mergefield
5. Run your mailmerge.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Thanks for both suggestions. I haven’t tried the StrConv function yet however will keep in my trouble shooting folder. Addressing the MERGE fields in Word works beautifully.

Reply | Quote