Re: Home Phone field not getting picked up in Merge

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Doug Robbins - Word MVP (dkr_at_NOmvpsSPAM.org)
Date: 01/06/05


Date: Thu, 6 Jan 2005 13:50:39 +1000

Initiate the mailmerge from Outlook.

See the "Mailmerge from Outlook" item on fellow MVP Graham Mayor's website
at
http://www.gmayor.com/mailmerge_from_outlook.htm

-- 
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
"Cathleen McGuire" <CathleenMcGuire@discussions.microsoft.com> wrote in 
message news:A58F9658-137F-47F0-BE84-F560559D356F@microsoft.com...
>I am trying to do a mailmerge my Outlook Contacts into a Directory so that 
>I
> can print the results and then physically paste them into my manual 
> address
> book. (Office version 2002)
>
> It’s driving me up a wall, but Home Phone just will not materialize. 
> Every
> other field value gets populated except for Home Phone.
>
> I get to Step 4 (“Arrange Your Directory”) and select the last option, 
> “More
> Items …” to insert the field names into the master directory document I’m
> creating.  (On the Mail Merge tool bar, the “More Items” icon is called
> “Insert Merge Fields”)
>
> While in the Insert Merge Fields window, one can select Address Fields or
> Database
> Fields. I don’t understand the difference between either of those options,
> but whatever. I try them both.
>
> If I select the Address Fields option, there is a Home Phone field, but as 
> I
> said, it doesn’t populate when the merge is run. The Home Phone post-merge
> values are left blank.
>
> If I select the Database Fields options, there is no Home Phone option. 
> (Go
> figure). So I click on “Match Fields” at the bottom of the window in order 
> to
> “use the dropdown lists to choose the field from your database that
> corresponds to the address information Mail Merge expects.”  Whatever that
> means.
>
> So I find the Home Phone field in the Match Fields options, but (true to
> Microsoft form) the dropdown box says “not available.”  Great!
>
> So how do I do a merge of my Contacts database so that the all-important
> Home Phone numbers appear? I’ve tried to do the Merge both from within
> Outlooks Contacts as well as from within Word. Both give me the same 
> cockeyed
> results as I’ve outlined above.
>
> This is driving me crazy!!!  Any and all help greatly appreciated.
> -- 
> Cathleen McGuire 

Quantcast