Mail Merge in word 07

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cmutech

Thread Starter
Joined
May 20, 2010
Messages
14
Hey Guys,

I have an end user who is needing to set up word 2007 mail merge. She is drawing her list of recipients from our SQL server database. She is needing to place up to nine names into a 3x3 table, with one name per cell. Our problem is that some of the schools she is doing this for don't have nine people. So not all nine cells are filled. Now the problem this causes is that when one page doesn't fill all of the cells word starts grabbing names that are supposed to be on the next page (school) and using them to fill the partially filled chart. This is a huge problem because each page is a different school with different Board members. So I need to figure out a way to separate the charts so that each page's chart is filled according to the School name that is pulled from the database. She is currently having to do a separate merge for each school, we have 56 different schools. And it is an extreme hassle for her. If you have any suggestions please let me know. Also if you need me to clarify anything, please send me a message.

Thanks
 

cmutech

Thread Starter
Joined
May 20, 2010
Messages
14
Name Name Name
Name Name Name
Name Name Name

It's going to look similar to that, but there is going to be a chart surrounding it. and each Name is a different board member. however some schools dont have 9 board members, and word is currently pulling the names from the next school on the list in order to fill all 9 cells. How do i Prevent it for doing this without having to do a new mail merge for each school?
 

cmutech

Thread Starter
Joined
May 20, 2010
Messages
14
What I'd like to do is mail merge from my data source into a Word table.
So, in order to put more than one record in the 3x3 table, I use the NEXT field
code in each new cell. The problem with this is that if I have 3 rows and 3 columns per
page. Now I'm filling each cell with an address block of each of the board member for a specific school. Now my problem is that some schools have less board members than there are cells to fill. But word starts to pull data from the next school in order to fill all 9 cells. and now I have a letter with board members from 2 different schools. Is there anyway I can cut word off once it has entered all the names from that specific school. and then pick up the data onto the next page with the new/correct school. Any suggestions? I don't even know were to start, and I've been at this for a few days now!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top