It's good to know there is a way to do it through Outlook, but I think the
way I use already is probably easier. I just export all the emails I want to
use into Excel, copy the email addresses and paste them into the BCC line.
Faster than manually copying addresses from individual emails.
This really should be an option built-in to Outlook though - "Reply to Many"
or something. When sending confirmation responses this is an essential tool
for most offices.
"Aligator" wrote:
> Yes you can manually put all receivers in the bcc line of your reply.
> If you don't have all their addresses in an addressbook or if there are
> really many , you could use a diffrent technique:
>
> First put all the mails you want to respond to in an extra folder.
> Then write the standard email you want to send them all.
> Save the email. It will go to "Drafts" folder. Now drag that email to the
> folder which contains all the emails you want to reply to.
> Make sure the folder is opened and your answer mail is selected!!
> Now press ALT+F11 and paste the macro at the end of the post.
> Hit F5 and wait for some time. You will see how many replies Outlook sent.
>
> Sub ReplytoALLEmail()
> Dim compteur As Integer
> Dim objFolder As Folder
> Dim objTemplate As MailItem
> Dim objItem As MailItem
> Dim objReply As MailItem
> Dim strEmail As String
> Dim strEmails As String
> Dim strBody As String
> Dim strSubject As String
> Set objTemplate = Application.ActiveExplorer.Selection.Item(1)
> Set objFolder = objTemplate.Parent
> compteur = 0
> strBody = objTemplate.Body
> strSubject = objTemplate.Subject
> For Each objItem In objFolder.Items
> If Not (objTemplate = objItem) Then
> strEmail = objItem.SenderEmailAddress
> Set objReply = objItem.Reply()
> objReply.Body = strBody
> objReply.Subject = strSubject
> On Local Error Resume Next
> objReply.Send
> compteur = compteur + 1
> End If
> Next
> MsgBox " Operation Successfull! " & vbCrLf & vbCrLf & "
> Sent " & compteur & " Replies "
> End Sub
>
>
> --
> I am what I am - the cow don''t make ham...
>
>
> "qlfwyyd" wrote:
>
> > If I have to send a standard form letter to many applicants, in response to
> > their email is there a way to reply to many emails at once? Perhaps by adding
> > all respondents to the BCC list?
> >
> >
|