• Can you send to more than one email address at once?

    By Laurence Sopala 7 years ago

    I'm testing it out, and was wondering if there's a way to send to more than one email address at a time.  I tried adding and loading more than one, but when the Mail Merge - Send agent was run, it only sent to thefirst listed email address.  I understand limits, to prevent spamming, but it would be nice to send to maybe 5 emails at the most.

    Thanks!

    -Laurence Sopala

    LSopala@hotmail.com

    • Comma-separate addresses? - WRONG

      By David Turner 7 years ago

      If your email addresses are in separate columns (and you don't want to CC some and BCC others) then you'll want to concatenate your addresses in the 'To' column of your spreadsheet, separated by a comma. Using a simple Excel formula to achieve this probably best.

       

      E.g. Supposing your email addresses are in columns G and H of your worksheet, in the first cell of the column you've set with the 'To' header, you could enter formula =G2&", "&H2 and fill down. This will insert both those recipient addresses into the 'To' field of the draft emails.

       

      UPDATE 14/06/2013: Additionally, you may be experiencing this problem with Notes/Domino treatment of RFC-822 internet addresses with commas. It appears you may be able to work around this issue by enclosing the separate names & addresses in quotes (and/or internet addresses in square-brackets).

       

      As per example above, if you need your addresses surrounded in quotes, try an Excel formula like: =""""&G2&""", """&H2&"""" or if you find it more readable: =CHAR(34)&G2&CHAR(34)&", "&CHAR(34)&H2&CHAR(34).

    • Pipe-separated addresses

      By David Turner 7 years ago

      I have confirmed that comma-separated addresses in SendTo fields are not split by Domino automatically, it is treated as one address. This will require a code change to fix, so I will provide this shortly in a new release.

       

      If your email addresses are in separate columns (and you don't want to CC some and BCC others) then you'll want to concatenate your addresses in the 'To' column of your spreadsheet, separated by a pipe character (|). Using a simple Excel formula to achieve this probably best.

       

      E.g. Supposing your email addresses are in columns G and H of your worksheet, in the first cell of the column you've set with the 'To' header, you could enter formula =G2&" | "&H2 and fill down. This will insert both those recipient addresses into the 'To' field of the draft emails.

    • Multiple-recipients added in v1.4

      By David Turner 7 years ago

      MailMerge v1.4 now supports multiple addresses in TO, CC, BCC recipient fields.

      Separate your addresses with pipe (|) or new-line (char:10 or Alt+Enter) characters.