Solved

Send mass email to friends

Posted on 2006-11-02
6
224 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
6 Comments
 
LVL 6

Expert Comment

by:tone28
ID: 17874469
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
ID: 17875196
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
ID: 17875436
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

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

Expert Comment

by:tone28
ID: 17875447
Also change

Set template = folder.Item(1)

to

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

Accepted Solution

by:
tone28 earned 125 total points
ID: 17875454
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can't transfer contacts in my iPhone to Outlook 23 61
Excel macro : save an outlook 2010 mail message to a folder 4 51
Outlook - Windows to Mac 7 36
exchange 13 18
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Read this checklist to learn more about the 15 things you should never include in an email signature.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

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