Solved

Send mass email to friends

Posted on 2006-11-02
6
227 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
Independent Software Vendors: 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 Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Read this checklist to learn more about the 15 things you should never include in an email signature.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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 …

739 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