We are exploring ways to reduce the number of spreadsheets that we use and move that data to ACT.
One of the things that we do often is generate invoices for a client's account. Many client's may have multiple accounts that receive a separate invoice. We created an account tab and listed all accounts for the contact's record. We then created dynamic groups and search quires that allow us to sort out these contacts who have accounts that get billed.
Here is where we run into a problem.
When we export to excel, the contact is listed on row 1 and the accounts follow each in their own column (based on the fields we export).
When we do a mail merge into our invoice word document the merge doesn't work correctly because each account needs its own row in the excel spreadsheet. This allows the invoice to reference the unique account no that the client is getting billed for.
It seems to me that to fix this we will need to add a contact to a group twice and then manually delete the account we don't want merged from excel.
Is there anyway to do this? We are very open to other idea on how to accomplish this so please feel free to share!. Thanks.
