MS Word mail merge .....

[camster39]

My word template has the following fields:

Company Name
Activity 1
Activity 1 Date
Activity 2
Activity 2 Date
Activity 3
Activity 3 Date

My data source (a CSV file), however contains multiple records for each activity for example......

ABCM Corp, Call Client, 1-12-08
ABCM Corp, Set Expectation, 2-14-08
ABCM Corp, Deliver Proposal, 3-1-08
etc....

When I merge to my doc I want to merge all the activities from the multiple rows above into one record. In the example above my merged doc should look like this...

Company Name: ABCM Corp.
Activity1: Call Client
Activity1 Date: 1-12-08
Activity2: Set Expectation
Activity2 Data: 2-14-08
Activity3: Deliver Proposal
Activity3 Date: 3-1-08

When I try to merge I would get three pages in the above example where I only want to get 1 page. Hope that makes sense? Thank you for any help.

 

[SkipVought]

Hi,

If it were me, I'd be doing this in Excel, where you can perform a one to many relationship taxk.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[macropod]

Hi camster39,

Word's mailmerge facility isn't designed for that type of merge - you need to reorganise the data so that all the fields for each record (company) are on the same line (ie multiple columns).

Cheers

[MS MVP - Word]