View Single Post
 
Old 05-14-2015, 03:36 PM
grumpybattler grumpybattler is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: May 2015
Posts: 4
grumpybattler is on a distinguished road
Default Mail merge to table, new page/doc when field chnges

Hi all

I'm hoping you can help me out here. part of my job is issueing regular crewtalks throughout the work force. The crew talk is generally a 1 page document and then added to that is a sign off page that all crew members must sign.

What I am trying to do is have a document set up so I can cut and paste the crew talk to first page then merge a table to the second page with the crew members Emp No and name and signature space and crew and have it start a new letter/directory when the crew changes


for example

(Page one)

Crew Talk Crew 1
Blah blah blah

(Page 2)

Crew Talk Crew 1
Delivered by__________ Date____________
(table)
Emp No, Name, Tick I have read, Signature, Crew
1, J blog, , , Crew 1
2, H Doer, , , Crew 1


(New doc)

(Page one)

Crew Talk Crew 2
Blah blah blah

(Page 2)

Crew Talk Crew 2
Delivered by__________ Date____________
(table)
Emp No, Name, Tick I have read, Signature, Crew
4, D Smith, , , Crew 2
5, A Jones, , , Crew 2




I have tried the <<Tablestart>><<tableEnd> commands and also the method used in gmayors tutorial but I always seem to end up with just the 1 name per signoff page ie 300 individuals instead of 20 crews

I'm a complete noob to this so any help will be greatly appreicated

At the moment the best I've been able to manage is a standard merge ignoring the names and just putting in a table with the crew inserted down 1 column

ie

Crew Talk <<Crew >>
Blah blah blah

(Page 2)

Crew Talk <<Crew>>
Delivered by__________ Date____________
(table)
Emp No, Name, Tick I have read, Signature, Crew
, , , ,<<Crew>>
, , , ,<<Crew>>
, , , ,<<Crew>>

Which is ok but makes tracking which crew members a have and have not signed clumbsy
Reply With Quote