Solved

Send mass email to friends

Posted on 2006-11-02
6
191 Views
Last Modified: 2010-05-18
I want to be able to send an email to all my friends in my Outlook address book.  It's almost like a spam message, like from buy.com or something like that. since I want to format the email with pics and stuff.  I just changed jobs to sell jewelry and I want to let my friends know about this change and what deals they can get if they buy this jewelry.  I don't know what this type of email would be called so I can't do a search to see if there is already an answer to my question.  

I would appreciate any help.
0
Comment
Question by:huerita37
  • 5
6 Comments
 
LVL 6

Expert Comment

by:tone28
Comment Utility
So you want to send individual emails but with similar content? Do you want to address your friends by name?
0
 

Author Comment

by:huerita37
Comment Utility
Yes, I want to send a message to all my friends by name but with the same body of information.
0
 
LVL 6

Expert Comment

by:tone28
Comment Utility
Ok, well I may be assuming some things but you let me know.

Here is the code you would past in your VB Macro

Sub SendSpam()
    Dim folder As Folders
    Dim drafts As MAPIFolder
    Dim ns As NameSpace
    Set ns = Application.GetNamespace("MAPI")
    Set folder = ns.GetDefaultFolder(olFolderInbox).Folders
    Set drafts = ns.GetDefaultFolder(olFolderDrafts)
   
    Dim objCont As MAPIFolder
   
    Set objCont = ns.GetDefaultFolder(olFolderContacts)
   
    Dim template As MAPIFolder
    Set template = folder.Item(1)
    Dim itm As MailItem
    Dim cnt As ContactItem
   
    For Each cnt In objCont.Items
       
        For Each itm In template.Items
            itm.Copy
            Set itm = itm.Move(drafts)
            itm.To = cnt.Email1Address
            itm.Body = Replace(itm.Body, "${name}", cnt.FirstName)
            itm.Save
           
            'itm.Send ' Uncomment this line to automatically send them
        Next
    Next
   
End Sub

' End VB Macro

Then what I did was I created a folder underneath my inbox and called it template. Then I entered in my Subject line and body like so

Subject: Cool

Hey ${name}, I just wanted to say something to you. OK?

Later.


As you can see I am using ${name} as the place holder for the name. You can add more and I hope my example gives you enough to generalize the enhancement.

Please let me know what you think and if you have any questions.

The way I ran this was by just going to Tools > Macro > Macros and running the ThisOutLookSession.SendSpam

Let me know

Tone
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 6

Expert Comment

by:tone28
Comment Utility
Oh this goes through your complete address book and sends the email.
0
 
LVL 6

Expert Comment

by:tone28
Comment Utility
Also change

Set template = folder.Item(1)

to

Set template = folder.Item("template")
0
 
LVL 6

Accepted Solution

by:
tone28 earned 125 total points
Comment Utility
Wow, I didn't explain things well did I.

for this part

----
Then what I did was I created a folder underneath my inbox and called it template. Then I entered in my Subject line and body like so

Subject: Cool

Hey ${name}, I just wanted to say something to you. OK?

Later.

---

I meant to say after you create the folder called "template" create a new mail message and fill in the Subject line and the body. Where you want the firstname of the person to appear put ${name}

I hope that clears it up
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Find out how to use dynamic social media in email signatures with this top 10 DOs & DON’Ts.
Outlook Free & Paid Tools
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now