Very long question, I apologize up front.
My company sells 3 types of a product. Each type of product has several different specifications. Each product is sold in various sizes, some types have only one, some types have as many as 5. We have roughly 500 customers, each has their own pricing structure depending upon their past purchase history. Each month, each customer receives a revised price list (3 pages, 1 page for each type) with current pricing. I currently have this working in a excel-word mail merge, but would like this to be in a database instead. I've tried to set this up in a database, but access-word merges don't work as I want them to. From other questions on this issue, everyone says to use the report function in access, but the formatting is very specific how the owner of the company wants it to be. Could anyone provide guidance as to what would be the proper way to set this up in access, if it is possible at all. I am attaching a basic layout of the spreadsheet (truncated to show sizes, types, & categories) I have setup and how the merged form needs to look like. spreadsheet.jpg