auto mailing of selective range as attachment
Hi
I am trying to send automail to various persons of various departments from
finance, please help me. As it is voluminous data and repeated task. Let me
explain what I am doing
I have 2 sheets
1 detail data sheet with autofilter ( I need to filter location code wise,
copy & paste in new work book and send as attachment to various people)
2 mailing information
Data in sheet 2 mailing information
Range a Sl No
Range b LocationCode
Range c Location Name
Range d Names (names of persons whose id is in range
Range e To IDS
Range f - CC IDs
Range g Instructions to type as body in each letter customized based on
data, which I will type and keep in advance
Range h Send / ignore to validate before sending mail, choose to send
mail if the cell has word Send
Range I - after sending mail, should store as Sent or Skipped (when
range h is changed to Send from ignore then mail need to be sent)
The macro should run automatically till the end of list in sheet 2 (70
locations approx), Auto mail is checked in Outlook so I can confirm manually,
bypass that checking is not available.
Can this be automated, please answer me by monday
|