Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Send mass email to friends

Posted on 2006-11-02
6
Medium Priority
?
236 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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 500 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
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…

722 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