• I need to pull data from specific ranges on different pages, put it into Outlook 2000/XP, then send an E-Mail to different people based on the vaule of one of the ranges. HELP!! Any ideas???

  • This code in module will send your workbook to recipients whose email addresses are in range A1:A2 of the current sheet and whose subject is in B1:

    Sub sendmail()
    Dim Recipients
    Dim Subject
    Subject = Range("B1")
    Recipients = Range("A1:A2")
    ActiveWorkbook.sendmail Recipients:=Recipients, Subject:=Subject
    End Sub

    To determine who gets what, make the email addresses conditional on the content.

    You have to be more specific about what data you want moved about for the other part of your question...


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!