starl
Administrator
- Joined
- Aug 16, 2002
- Messages
- 6,091
- Office Version
- 365
- Platform
- Windows
I'm helping someone out with this, I don't have any real data or template. And I'm terrible at Word merges. I've looked online and haven't found a solution. So I'm trying to think outside the box.
Have a bunch of records. Some of those records belong to the same person. Want to do a mail merge where pages 1 & 2 (front & back) are an address label and the rest of the pages are the invoices each record represents. Some people only one invoice, so their print out would be
Page 1/2: Address Label
Page 3/4: Invoice
But some people have multiple invoices, so their print out would be:
Page 1/2: Address Label
Page 3/4: Invoice A
Page 5/6: Invoice B
I thought an If/then, but that's only for including specific text, not merge fields.
I thought if I blanked out the Address Label merge fields in the data set, it would skip generating the Address Label, but I get a blank page.
I'd like to compare the mergefield of the current record with the previous or store a variable from the previous record, but that doesn't seem possible.
Is there a way to do this with Word's built-in Word Merge logic? The solution is limited to that - I can already do a VBA solution.
Have a bunch of records. Some of those records belong to the same person. Want to do a mail merge where pages 1 & 2 (front & back) are an address label and the rest of the pages are the invoices each record represents. Some people only one invoice, so their print out would be
Page 1/2: Address Label
Page 3/4: Invoice
But some people have multiple invoices, so their print out would be:
Page 1/2: Address Label
Page 3/4: Invoice A
Page 5/6: Invoice B
I thought an If/then, but that's only for including specific text, not merge fields.
I thought if I blanked out the Address Label merge fields in the data set, it would skip generating the Address Label, but I get a blank page.
I'd like to compare the mergefield of the current record with the previous or store a variable from the previous record, but that doesn't seem possible.
Is there a way to do this with Word's built-in Word Merge logic? The solution is limited to that - I can already do a VBA solution.