Editing mailing labels

[Guest]

I am attempting to create mailing labels from access. The label wizard is
great, however, it doesn't allow me to edit the finished printable sheet. I
find that I have friends with many different naming conventions (i.e. Mr. &
Mrs. Smith, John & Jane Doe, John Smith & Jane Doe, Dr. Jane Doe & Mr. John
Smith, etc.). I haven't found a way to accommodate all of these naming
conventions in the mailing wizard. So I find I need to edit them before I
print. I can't do this in access. Do I have to convert the entire database to
Excel to be able to edit the labels? I believe I can edit the printable sheet
in Word. Or convert it all to Outlook (I'm not nuts about this option because
there are addresses in the access database that are related to my parents'
needs, not mine). I'd appreciate any help anyone can give me. Thanks.

 

[Tom]

Suggest you set up a salutation field in the database and in that you can
name your friends in the convention you prefer. That salutation field is
then used, with your address fields, in your mailing label.
You might also add a check box as well and tick if the contact is 'yours' or
leave blank if your parents. A query, using the -1 value of that check box
will produce a list of just your contacts.

Tom

 

[Guest]

Ah, clever man! Thank you. Creating a salutation field will solve my mailing
address problem. The parent vs. my contact issue is well in hand in Access.
If I were to convert my Access database to Outlook I'd be looking for some
help making those definitions. I am, fortunately, not there yet.

Thanks again for the idea!

 

[Guest]

I am attempting to create mailing labels from access. The label wizard is
great, however, it doesn't allow me to edit the finished printable sheet. I
find that I have friends with many different naming conventions (i.e. Mr. &
Mrs. Smith, John & Jane Doe, John Smith & Jane Doe, Dr. Jane Doe & Mr. John
Smith, etc.). I haven't found a way to accommodate all of these naming
conventions in the mailing wizard. So I find I need to edit them before I
print. I can't do this in access. Do I have to convert the entire database to
Excel to be able to edit the labels? I believe I can edit the printable sheet
in Word. Or convert it all to Outlook (I'm not nuts about this option because
there are addresses in the access database that are related to my parents'
needs, not mine). I'd appreciate any help anyone can give me. Thanks.