Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2007

Tip: Looking for answers? Try searching our database.

Can I add Job title to address block in a word mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MKLeisure - 31 May 2007 20:19 GMT
I need to add a job title to the address block in a word mail merge. THe
result must contain the following fields

Title   FirstName  Initial Lastname
JobTitle
Company Name
Address1
Address2
City, State zipcode

I know I can add each of these manually but I need to be able to add them to
the address block
Thanks!
Peter Jamieson - 31 May 2007 21:08 GMT
Which version of Word and what is your data source?

Making some guesses...

If you are using the Mail Merge Wizard in Word 2002/2003 to get your data
from Outlook, you never see the Job Title. What you see is a field called
Title which is the "Courtesy Title", e.g. "Mr.", "Dr.", etc. To see the Job
Title field you have to initiate the merge by opening Outlook, opening your
contacts folder, going to Outlook|Tools|Mail Merge and following the
instructions.

If you are already doing that, or you are using a different data source,
then you have to click the "Match fields" button in the Address block setup
dialog box, and specify which field in your data source you want to use as
the Job Title.

Peter Jamieson

>I need to add a job title to the address block in a word mail merge. THe
> result must contain the following fields
[quoted text clipped - 10 lines]
> the address block
> Thanks!
MKLeisure - 31 May 2007 21:25 GMT
I am using the mailmerge in Word 2003 but my data source is Access. I have
tried to match fields but did still did not get the results. If I undersand
you correctly, I cannot add the job title,ie CEO ABC Corporation, to the
address block because there is no predefined location for it.

> Which version of Word and what is your data source?
>
[quoted text clipped - 28 lines]
> > the address block
> > Thanks!
Peter Jamieson - 31 May 2007 21:53 GMT
> you correctly, I cannot add the job title,ie CEO ABC Corporation, to the
> address block because there is no predefined location for it.

As far as I know, you are correct, i.e. there is no way you can easily get
the ADDRESSBLOCK field to show /both/ Job Title /and/ Company name at the
same time.

If Addressblock doesn't do what you need, in most cases you will probably be
better off constructing what you need using individual MERGEFIELD fields and
IF fields.

If absolutely necessary, you can use Alt-F9 to view the content of the
ADDRESSBLOCK field, then inset a second line that consists of a { MERGEFIELD
yourjobtiltefieldname } field, where you use ctrl-F9 to insert the ()
surrounding the mergefield. The result of the mergefield will be inserted as
text in your ADDRESSBLOCK. However, if you or your users edit the
ADDRESSBLOCK field in any way, the { MERGEFIELD } field will probably be
deleted or overwritten.

Peter Jamieson

>I am using the mailmerge in Word 2003 but my data source is Access. I have
> tried to match fields but did still did not get the results. If I
[quoted text clipped - 39 lines]
>> > the address block
>> > Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.