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:
Subject = Range("B1")
Recipients = Range("A1:A2")
ActiveWorkbook.sendmail Recipients:=Recipients, Subject:=Subject
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...