Mail merge

[cluser]

We would like send letters to parents of students.

We have an excel sheet of all students information, including address.

How can I use mail merge to send mail for each family and including all their kids information in one letter?

I think may be group address, but don't know how to do it, any suggestions would be appriciated.

 

[SkipVought]

It can be done in Excel. Check this our for a general approch...

Mail Merge in Excel faq68-4223

Specifically, your database table needs to be structured like this...
[tt]
Parent Student
A Child1
A Child2
B Child1
C Child1
C Child2
C Child3
...
[/tt]
It could be as simple as a Subtotal on Parent. Of you could construct a sheet form, perform a parameter query on the table that returns the Student for the Parent to the form. Each time the cell containing the Parent changes, the query returns the Student(s) for that Parent. It could all be done in a simple loop.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[cluser]

Thank you very much, I found we had a word document built like that, so still want to use it as a template,

SO there is no way to do it in word?

Thanks

 

[Xaqte]

Until Skip gets back to you, here is some documentation that might help:

http://office.microsoft.com/en-us/assistance/HA010349201033.aspx

X

 

[SkipVought]

The only way that Word could work is to have Child1, Child2, Child3, Child4. fields. Works, until you have a parent with Child_{n + 1} children.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[tf1]

I'd suggest converting the database into simple Access database. Then you can have tables for parents and a separate table for children. Mailmerge to Word based on parents rather than children - the merge collecting all linked children to a parent.

It may be possible to do this with an Excel type database. Hopefully an Excel wiz can throw some light on this for you.

Regards: tf1

 

[SkipVought]

tf,

no need to cast it into Access. You can do exactly the same thing in Excel, query etc.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[IBACFII]

Ok I think that my question is along the same topic.
I am trying to merge mail from a SQL DB to this mailer document. I have one table with a top level listing. This would be the data that would need to define a different mailer, and then another table with the data for the mailer. My question is "what is the best way to convert the SQL data for the mailer?" IE a text doc or access db or some thing else.

Thanks
IBACFII

 

[SkipVought]

IBACFII,

Please post your question in a new thread.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}