Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
OfficeNDN[_2_] OfficeNDN[_2_] is offline
external usenet poster
 
Posts: 20
Default Employee phone list in directory tool under mailmerge

I am trying to create an employee phone list using mail merge and the
directory tool.
My list is an Excel database. The column headings are "extension number",
"first name", "last name", "department", and "Heading" in that order starting
in column A.

I would like to have the heading listed first ( the heading contains unique
info like mailing address and government program), then the department
(within the government program), the first name, the last name and then the
employee's extension.

I can get all to list easy enough but all five items show for each and every
extension number which makes for a long list.

I would like to have the "heading" and "department" listed only once then
have all the employee's numbers for that department listed. Then when there
is a new department the "heading" and "department" would list again one time.

How can I do this?
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phone directory: how repeat data fields per table cell per record earlylynn Page Layout 3 July 30th 07 10:56 AM
phone directory with addresses and phone number from existing fi. Nicky Mailmerge 1 October 11th 06 04:47 AM
How can I avoid only getting a 0 when mailmerge an itn'l phone nu. Kathym Mailmerge 5 January 19th 06 08:13 PM
How do I set up a address,phone and email list? cv Microsoft Word Help 2 October 27th 05 07:57 AM
print phone directory with notes from outlook into word using mail rirunyan Mailmerge 1 May 6th 05 01:47 PM


All times are GMT +1. The time now is 07:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"