Macro to create multiple email messages in Outlook 2003
Is there a way to create multiple email messages, all with the same subject and body text but with different email addresses (to & cc) and different attachments?
Software/Hardware used:
Outlook 2003 on Windows XP
Software/Hardware used:
Outlook 2003 on Windows XP
ASKED:
April 19, 2010 8:20 AM
UPDATED:
April 19, 2010 3:22 PM
Answer Wiki:
You could use Windows Powershell and use this script:
$srvName = "Spooler"
$EmailAddress = Gc "list.txt"
foreach($EmailName in $EmailAddress)
{
$ol = New-Object -comObject Outlook.Application
$mail = $ol.CreateItem(0)
$Mail.Recipients.Add("'$EmailName'")
$Mail.Subject = "PS1 Script TestMail"
$Mail.Body = "
Test Mail
"
$Mail.Send()
# you can use this for HTML-Mails
# $Mail.HTMLBody = "<HTML><HEAD>Text<B>BOLD</B> <span style='color:#E36C0A'>Color Text</span></HEAD></HTML>"
# you can use this for attache a file
# $Mail.Attachments.Add("D:scripteol.txt")
}
To see all answers submitted to the Answer Wiki: View Answer History.
You could also use the Mail Merge facility in Microsoft Word and using a data file (Excel, CSV text file, etc,) with the To: and CC: addresses.
You can even customise the salutation and email body for each mail recipient.
http://office.microsoft.com/en-us/word/CH100626281033.aspx