However, in this particular invoice form, I have to create a seperate listing in the description field for each product a publisher sold (including how many they sold and how much money they are owed). Issue 2: Bookmarks seem like a nice way to use VBA to replace their values with excel data (in theory, i've only read about it and never attemped). Any Ideas on how to automate that, as we have 100's of publishers and invoices are done every month. I could create a seperate database in excel with each publishers address and name but then it might get difficult to match these up. Would it be possible to create an initial template for each publisher and then have the rest of the information be populated with the data from the CSV that has their sale information.

The problem is, the information i'm pulling the number of sales (and money we owe them) is from a different spreadsheet every month and wouldn't contain this address information on it as it is an aggregate spreadsheet of ALL publishers numbers. Issue 1: Each Invoice form has the publishers Name and Address listed at the top of the form. I'm not sure how to attach the sample invoice, so i'll do my best to write them out and if i figure out how to attach a doc by the end of this i will include a sample so you see what I'm talking about. I'm having a couple of issues logistically though. Then I would use VBA to populate those bookmarks based on the person (publisher in this case) i was invoicing. The way that I was thinking about doing this would be by creating a template in word and using bookmarks. Essentially, I need to take a bunch of information that I have in excel and populate a Word Document to create an invoice.

I've tried searching this form (and google) and I haven't quite found what I'm looking for so i figured I would ask a question.

Create invoice template in word