Customizing Address Book Application

G

Guest

My boss uses the Insert Address from the Outlook Address Book to prepare
proposals and invoices. The feature inserts the name and address fine, but
we would also like it to insert the Company Name (bolded), and the
salutation. Can anyone tell me how to either customize this feature, or
create one with VBA to achieve this?

Thank you.

Sprinks
 
G

Guest

Graham,

Seems I spoke so soon. Part of the problem is that I've used VBA in Excel &
Access but don't have any experience in Word.

I've adapted the code in the link to my application, and it is now inserting
the correct information. I would like it to do two additional things, bold
the Company name, and insert the Salutation/Last Name in the "Dear Mr.
So-and-So" clause, which is below the Subject line. As a sample, it should
read:

Mr. John Smith
XYZ Corporation ' This line bolded
Somewhere, NY 11111

Re: {Subject Line prompt}

Dear Mr. Smith,

....

Thank you for your help.
Sprinks
 
G

Guest

Graham,

Seems I spoke so soon. Part of the problem is that I've used VBA in Excel &
Access but don't have any experience in Word.

I've adapted the code in the link to my application, and it is now inserting
the correct information. I would like it to do two additional things, bold
the Company name, and insert the Salutation/Last Name in the "Dear Mr.
So-and-So" clause, which is below the Subject line. As a sample, it should
read:

Mr. John Smith
XYZ Corporation ' This line bolded
Somewhere, NY 11111

Re: {Subject Line prompt}

Dear Mr. Smith,

....

Thank you for your help.
Sprinks
 
G

Graham Mayor

In investigating this I found my coding hard to follow, so I have revised
the code already on my web site and I have modified the macro and a further
version (which is now uploading) at
http://www.gmayor.com/Macrobutton.htm#template

The modified code will prompt for the subject line and format as requested.
It also adds the current date, though you can leave this out if you wish. If
you don't know how to do that, contact me via my web site link.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Graham Mayor

In investigating this I found my coding hard to follow, so I have revised
the code already on my web site and I have modified the macro and a further
version (which is now uploading) at
http://www.gmayor.com/Macrobutton.htm#template

The modified code will prompt for the subject line and format as requested.
It also adds the current date, though you can leave this out if you wish. If
you don't know how to do that, contact me via my web site link.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Guest

Thank you, Graham. I was able to customize your code for it to do exactly
what I want.

Sprinks
 
G

Guest

Thank you, Graham. I was able to customize your code for it to do exactly
what I want.

Sprinks
 

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

Similar Threads

Insert Address from Address Book 2
Address book Select Name dialog shows only Contacts with email add 8
How do I create my electronic address book? 1
Word Create a Phone Book using MailMerge in word 2007 0
Address Book versus Autocorrect in Word 2007 4
Sorting the Address Book in Word 2003 1
Address Book crashes Word 2007 3
Insert Address Button v. Envelopes 2

Top