Solved

Send mass email to friends

Posted on 2006-11-02
6
204 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
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is it safe to Allow Malformed MIME? 5 43
certificate error when opening outlook 2016 4 52
Microsoft Edge, Outlook OWA 7 43
exchange, outlook 4 18
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
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.
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

895 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

19 Experts available now in Live!

Get 1:1 Help Now