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 SubTo 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...
Joel