mail merge

[reed222]

Can someone please tell me the best way to set up a mail merge (for printing labels) using data in a SQL Server file? I'm currently trying to do it using tables in access that are linked to SQL Server tables, but I'm having a heck of a time. Has anyone figured out a better way to do this?

Thanks in advance,

Reed

 

[fluteplr]

do you have access (no pun intended) to Word? If so you can create a view in sql server the select the data you need and use Word to access that view using ODBC. You can then format the labels in Word. You should also be able to do that in access by writing a report directly against sql server depending on what version of access you have. Then there is also Crystal reports etc.