Forum Discussion
Nextif Function and Mail Merge
fabiodero79 were you ever able to get this to work? Is it possible the NEXTIF logic has morphed into something else in a newer release of Excel? I'm stuck on the same problem.
MarthaN I'm working on this right now for my own project (with a bunch of tables I want to populate, which seems to be a bigger hassle,) and NEXTIF progresses my mail merge just fine.
Actually getting the mail to only display information that is new involves more steps, namely placing that information inside of an if statement.
Your subsequent lines should look something like { NEXTIF condition1 = condition2 } {If condition1 = condition2 {MERGEFIELD "Item"} }
I found it easiest to add columns to excel for my conditions (true/false)-
and if so desired, a column to COUNT how many times a customer appears on the list, which only appears on the first line of mail merge for that page.
- Oh, I misread the subtotals idea. As presented in the original post, you would need to make a string out of the name + " total" and use that as a condition in the final line on a page (or organize your original table so that the subtotal appears on the first line instead of the last, or in another column, etc.)
