Mail Merge doesn't respect filter settings

Bugs
1

We are using the mail merge function to generate multiple Excel files in a zip-file.

There are subtables in the mail merged records that collects data from another table.
The subtables have a fixed default filter (we even tried to set a fixed filter on parent record)

But what ever we do …

The mail merge contains all possible subtable entries, not only the filtered ones.
Is there a work around to merge only the filtered items?

Kind regards
Oliver

We consider this a bug, so we put it in this category - please move if we are wrong

2

Hi,

This is currently not supported. I’ve forwarded your feedbacks to our development team and will let you know once it’s online.

3

Is there a way to use mail merge on address labels? I can get it to merge just one of the addresses but I would like to put several different addresses on the same label sheet.

1 Like
4

Hi,

As I’m not quite sure about what you meant, do you mind sharing with us an actual example with some screenshots to refer to?

(Please note that you cannot mail merge from multiple fields that share with same field names, you will need to use different names both in sheet design and mail merge formatting file, or you can use field ids as the parameter in your mail merge formatting file.)

Thanks!

5

Hi Amy

I have build an example on https://www.ragic.com/DACEE/

There is a subtable in the Objects Sheets linked to the Parts Sheet, showing only the Parts marked as New - do a mail merge and the filter is ignored.

There is a shared view “Only new Parts” filtering out the used Parts - do a mail merge and the filter is ignored.

Do not hesitate to contact me, when anything about that problem can be fixed on our side.

Best
Oliver

6

Hi Oliver,

Sorry for the confusion. I was actually replying to @judgmentclaims.

For the issue you reported, as mentioned in previous reply that I’ve forwarded to our development team and will let you know once it’s fixed.

7

Thank you.

1 Like
8

Hi Oliver,

This issue is now fixed. For on-premise users, you will need to wait for the patch after August 15.

Best,

9

Hi Amy,

The project I am working on needs to print many labels based on a record list sheet with a fitler. When we mail merge to Excel it only prints one record. I see your document https://www.ragic.com/intl/en/doc/37/Mail-Merge#7 sates that Excel does not support multiple entries and we should create multiple entries in word for the amount of entries we need. The problem is that if the client wants say 100 labels then we would need to copy and paste the label entry 100 times.

Is this the only way to do this or is there another way or something I am missing?

Thanks a ton

1 Like