Sajweet
04-08-2013, 10:53 PM
Hello,
I'm hoping someone out there can help me. I've made macros in excel before, but VBA is still a mystery to me. I'm using Outlook 2007.
Every morning for work, I'm required to send multiple (nine) emails to our creditors with an individual attachment sent to each. The emails are near identical, same subject and message, only the To and attachements vary.
What I'd like to do, would be to progammatically create nine new emails, each addressed to the respective creditor. I have an incredibly simple script that opens a single new email, but would like to steamline the process further.
What I currently have:
Sub NewEmail()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.To = "someone@email.com"
msg.Subject = "Email Subject"
msg.Display
End Sub
What I would like to have:
A macro that
- opens 9 emails, each one addressed to a separate email address
- Populates the From field with my adress
- Populate the subject and body with a simple message.
I'm sure this is a very simple question, and one that has probably been answered before, but any help or guidance you can provide would be greatly appreciated.
I'm hoping someone out there can help me. I've made macros in excel before, but VBA is still a mystery to me. I'm using Outlook 2007.
Every morning for work, I'm required to send multiple (nine) emails to our creditors with an individual attachment sent to each. The emails are near identical, same subject and message, only the To and attachements vary.
What I'd like to do, would be to progammatically create nine new emails, each addressed to the respective creditor. I have an incredibly simple script that opens a single new email, but would like to steamline the process further.
What I currently have:
Sub NewEmail()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.To = "someone@email.com"
msg.Subject = "Email Subject"
msg.Display
End Sub
What I would like to have:
A macro that
- opens 9 emails, each one addressed to a separate email address
- Populates the From field with my adress
- Populate the subject and body with a simple message.
I'm sure this is a very simple question, and one that has probably been answered before, but any help or guidance you can provide would be greatly appreciated.