Formating for Mail Merg

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon to you all:
I have a database that is all uppercase. When I do a mail merge I would
like to be able to change the format to "Proper" like you can do in Excel.
Proper dosen't work in Access, is there a way to do it?

Secondly, when I merge a phone number, it drops the formatting for the
number and only places a number 1234567890 in the letter.

Any help appreciated.
Thanks
Billa
 
You can use a query for you mail merge with the StrConv() function:

FirstName: StrConv([FName],3)

For the phone number, you need to build a correct expression using Left(),
Mid(), and possibly Right() to parse out sections and concatenate them
together with "-" between the sections.
 
I have a database that is all uppercase. When I do a mail merge I would
like to be able to change the format to "Proper" like you can do in Excel.
Proper dosen't work in Access, is there a way to do it?
Click to expand...

If your data is sufficiently well-structured that you can handle it all with
a simple conversion to Proper, it is far better structured than most. All
Proper does/can do is to capitalize the first letter of each word... do you
know of OCONNOR is Oconnor or OConnor, or if DICICCO is Dicicco or DiCicco?
Or if actress BARBARA BEL GEDDES ("Miss Elly" on Dallas) is Barbara Bel
Geddes or Barbara bel Geddes (in fact, if it is the latter, that's not what
you will get by converting to proper case)?

It is irritating to people to get mail with their name misspelled or
mishandled. You might well, from a recipient psychology point of view, be
better off to leave the names all in capital letters.

Larry Linson
Microsoft Access MVP
 
Thank you both for you help.
You are right Larry, that is something to consider.

Thanks again
Billa
 
Back
Top