Titles and/or suffixes don't print on envelopes Outlook/Word 2007

R

rdbico

I've created contacts in Outlook 2007. When I am in Word 2007, and click on
"Mailings", then "Envelopes", then choose a name from the Address Book, the
Title (Dr., Mr., Mrs., etc.) or suffix (Jr., III, etc.) do not print on the
envelopes. Any advice on how to get these two items to print??? Thanks.
 
G

Graham Mayor

The list of fields that you can use from the AddressBook (using the
addresslayout autotext) is explained at
http://www.gmayor.com/Macrobutton.htm

If you need the initial e.g. Mr. G. Mayor, then you will have to insert the
address using vba and that too is explained in that link.

It gets more complicated if you need the suffix as that is not one of the
available fields for this function. You may be able to cobble something
together using the DisplayName field or you could extract the extension from
the DisplayName field in vba and insert it along with the surname (though I
suspect you would need to know all the possible suffixes that exist in your
data file before working out whether a suffix exists in the displayname), or
you might consider mail merge
http://www.gmayor.com/mailmerge_from_outlook.htm

Fellow MVP Greg Maxey also has a function on his web site for inserting
addresses in Word 2007, based on an idea we had dscussed privately. It is
somewhat slower to use than InsertAddress or the macro on my web site, but
it could provide the extra flexibility you require - you will however have
to stretch your knowledge of vba to get it to work for you ;)
http://gregmaxey.mvps.org/Office Interoperability.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top