merging with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ramidale - 23 May 2006 21:51 GMT

In my excel worksheet the name of one indivudial is listed several times,
with each line containing a differnt job. I need to list all jobs on the same
letter in word. When I try to merge this, it gives me a new letter for each
job.....not each name. How can I fix this.......let me add, I am not that
good in either word or excel. lol

Reply to this Message

Doug Robbins - Word MVP - 23 May 2006 21:53 GMT

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> In my excel worksheet the name of one indivudial is listed several times,
> with each line containing a differnt job. I need to list all jobs on the
[quoted text clipped - 3 lines]
> job.....not each name. How can I fix this.......let me add, I am not that
> good in either word or excel. lol

Reply to this Message