SQL & MS Publisher Mail Merge Recipients

Question

Hey guys, been searching and reading and just keep getting lost, so I'm throwing this out to the world to see where I can get.

I'm working on a MS Publisher document for company birthday cards.  What I'm trying to do next is query SQL to get a list of employees with a birth date withing a date range.  The date range comes from user input when the Publisher document is open.  The user input has already been coded and validated, the problem I'm having is connecting to the SQL db, query it, and then turn the results into the mail merge recipient list so the user can then print all of the cards automatically.

Hopefully that's enough info and hopefully I posted this in the right forum.

Answer 1

For the first problem (query itself) check

http://berezniker.com/content/pages/sql/microsoft-sql-server/birthday-query-ms-sql-server

For the second problem I think this blog may help

Creating Mailing Labels in SQL Server Reporting Services

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Sorry, should have specified I was good on the SQL query, just getting the data to where I can use it was where I was thrown off.

Thank you very much for the SSRS link, it looks like I can adapt that, but I am very green on SSRS.  I have the report so it shows the information I want on separate pages for each employee.  The problem I can see happening is this:

Basically our vendor is giving us customized birthday cards with our logos & static information.  The names are dynamic and will come from printing the SSRS report on top of the cards.  The issue is going to be the size of the name as I have a limited amount of space for the name to appear.  Is it possible to create the text box as the article you linked shows but have the text size dynamically change so it fills but does not exceed the width of the text box?

Beyond that it looks like it will work perfectly and thank you for the response.

Answer 3

By george I think I have it!

Thanks Naomi for pointing me in the right direction, it's doing exactly what I need now.

Thanks again.