Results 1 to 1 of 1

Thread: sending multiple emails with redemption in excel

  1. Apr 27th, 2004, 05:09 PM #1
    LodBot
    LodBot is offline

    Thread Starter
    Member
    Join Date
    Jul 2003
    Location
    Los Angeles, CA
    Posts
    49

    sending multiple emails with redemption in excel

    Ok so I got redemption to send an email. But the problem is I have a list of emails and I need to send an email to each person on the list. I can't get redemtion to send an email when I use a variable to define the recipient.
    VB Code:
    1. Dim SafeItem, oItem 

    2. Set SafeItem = CreateObject("Redemption.SafeMailItem")

    3. Set oItem = CreateItem(0)

    4. SafeItem.Item = oItem

    5. SafeItem.Recipients.Add email

    6. SafeItem.Recipients.ResolveAll

    7. SafeItem.Subject = "Subject"

    8. SafeItem.Send
    The first time the loop runs, email will be [email protected], the second time, [email protected] and so on. Currently, no emails get sent at all. Any ideas what's wrong?

    Thanks in advance.

    EDIT: If redemption won't allow me to send multiple emails, is there any other method of doing so?
    Last edited by LodBot; Apr 27th, 2004 at 05:23 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width