SendForReview

roelof · Post by **roelof** » Thu Jul 31, 2008 12:55 pm

Ive got an excel workbook that needs to be commented on before general publication. Does anyone know how i could possibly send an email from MacroS via the SMTPSendMail to accomplish this? The excel equivalent is SendForReview.

Thanks

Bob Hansen · Post by **Bob Hansen** » Fri Aug 01, 2008 1:37 am

Use SMTPSendMail with the spreadsheet as an attachment.
=========================
From the HELP:

SMTPSendMail>recipients,server,from_address,from_name,subject,body,attachments
Sends email via an SMTP server to the recipients entered.

recipients : Include one or more email addresses, separated by semicolons (;).

server : The name or IP address of your SMTP server.

from_address : Your email address, or the email address you want the message to come from.

from_name : Your real name, or a string to appear in the from name field.

subject : The subject line.

body : The body text of the message.

attachments : if sending files include each file separated by semicolons (;). If no attachments end the line with a comma.