If you have a list of customer emails and need to paste them into the Sender and/or Recipient box in MessageWatcher then you can use this nifty formula in Microsoft Excel:

You can combine all values from a column into a single comma-separated cell using the TEXTJOIN function in Excel.

First, open or create a spreadsheet that has all of your clients’ email addresses in one column.  Next, use the formula below, in a cell on that same spreadsheet or in a new workbook.  In the example below your clients’ email addresses are in Column A.

=TEXTJOIN(“, “, TRUE, A:A)

**Explanation:**

* `”, “` → delimiter (comma + space)
* `TRUE` → ignore empty cells
* `A:A` → the column you want to combine

If you only want a specific range (e.g., A1:A100) then use something like this example for a list with email addresses in cells A1 – A100:

=TEXTJOIN(“, “, TRUE, A1:A100)