Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2015, 03:36 PM
grumpybattler grumpybattler is offline Mail merge to table, new page/doc when field chnges Windows Vista Mail merge to table, new page/doc when field chnges Office 2010 32bit
Novice
Mail merge to table, new page/doc when field chnges
 
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
  #2  
Old 05-14-2015, 09:47 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge to table, new page/doc when field chnges Windows 7 64bit Mail merge to table, new page/doc when field chnges Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,829
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

You can do that with http://www.gmayor.com/ManyToOne.htm , provided your crew list is in Excel and you have the Crew number as they key field and the data is sorted on that field. Use the optional list field for the signature block (if you want that also).
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-17-2015, 01:47 PM
grumpybattler grumpybattler is offline Mail merge to table, new page/doc when field chnges Windows Vista Mail merge to table, new page/doc when field chnges Office 2010 32bit
Novice
Mail merge to table, new page/doc when field chnges
 
Join Date: May 2015
Posts: 4
grumpybattler is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Thanks, I will look into it. I'm restricted on what I can download and install as on a work server but I'll see if I can get the ManyToOne installed
Reply With Quote
  #4  
Old 05-17-2015, 06:06 PM
grumpybattler grumpybattler is offline Mail merge to table, new page/doc when field chnges Windows Vista Mail merge to table, new page/doc when field chnges Office 2010 32bit
Novice
Mail merge to table, new page/doc when field chnges
 
Join Date: May 2015
Posts: 4
grumpybattler is on a distinguished road
Default

Thanks Graham. I will look into it. As I'm on a work server I'm not sure if I can install the add on. Doesn't seem to be letting me copy the supplied template to the start up file.

Will chase it up. Is there another way to do it if I can't use many to one?
Reply With Quote
  #5  
Old 05-17-2015, 10:48 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge to table, new page/doc when field chnges Windows 7 64bit Mail merge to table, new page/doc when field chnges Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,829
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

Not if you want to use a table, unless you program, it from scratch. If you can manage with a list, see Paul Edstein's mail merge tutorial which you can download from the download page of my web site. http://www.gmayor.com/downloads.htm, but it is a complex procedure.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 05-19-2015, 04:13 PM
grumpybattler grumpybattler is offline Mail merge to table, new page/doc when field chnges Windows Vista Mail merge to table, new page/doc when field chnges Office 2010 32bit
Novice
Mail merge to table, new page/doc when field chnges
 
Join Date: May 2015
Posts: 4
grumpybattler is on a distinguished road
Default

Thanks.

I haven't been able to get the manytoone addin working on my system but will pester IT to make it avaible
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Field Not Populating JennEx Mail Merge 3 05-10-2015 09:30 PM
Mail merge to table, new page/doc when field chnges Mail Merge - Age field jay_son Mail Merge 1 06-30-2014 02:33 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail merge to table, new page/doc when field chnges How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Mail merge to table, new page/doc when field chnges How big can a mail merge field be? Engineer Mail Merge 2 12-11-2012 01:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft