Oct 28, 2021, 3:32:55 AM10/28/21
to AnyMerge Mail, Jack, AnyMerge Mail, Stanislav Tvarůžek
The add-on updates only columns that are set up in the mapping editor. For example, it inserts a timestamp into a mapped column or a draft id. It does not modify user data at all.
It only reads entire rows to be able to merge the row data.
Either it cannot read data in that protected range or yes the highlighting of rows might be causing issues. In that case, the add-on only changes the background color, not the data.
I might add a flag in the next versions to disable the highlighting.
For now, the only workaround I can think of is to create another sheet without protected ranges and refer from that sheet data which needs to be merged into emails. So users enter data only into sheets with protected ranges. But the add-on then operates in a sheet where are all data references from other sheets and does the merge.
On Thursday, October 28, 2021 at 9:10:29 AM UTC+2 Jack wrote:
The issue I have is I created a working sheet for a team to work on.
I need to protect the entire sheet beside a few cells for them to be able to only write over a few formula.
But the tools progress bar needs to be able to write the entire rows, which prevents me from protected the range or anymerge stops the process.
COVID Testing Today