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