Microsoft KB Archive/50455

{| = Excel: Recording Macro with Send Mail to a Group Doesn't Work =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q50455

SUMMARY
When recording a macro in Microsoft Excel version 2.20 that performs a Send Mail to a group address, the resulting macro command will be incorrect. For example, when recording a macro that sends a file to a group called &quot;Agents&quot; on a server called &quot;Marketing&quot;, the macro statement will resemble the following:

=SEND.MAIL(&quot;Agents@Marketing&quot;,&quot;Worksheet name&quot;,FALSE) This will not work correctly because groups are not designated by the server on which they reside but by the word &quot;Group&quot;. To correct the above example, replace the name of the server (&quot;Marketing&quot;) with the word &quot;Group&quot;.

For example:

=SEND.MAIL(&quot;Agents@Group&quot;,Worksheet name&quot;,FALSE) The macro should now run correctly. Microsoft is researching this problem and will post new information here as it becomes available.
 * }