Emailing workbook which is already a macro output !

Dear Experts ,


Firstly this is a extension of the project

http://www.excelforum.com/excel-prog...62#post2842962

Basically the output of a macro execution leads to a filled workbook which i want to send to selected reciptents using used fed data in sheet 1 in cells N3,03,P3,Q3,R3 respectively

The attached files show the workbook before macro execution and after macro execution

In the input file itself i now specify CC,BCC ,body ,subject -see the input sheet and tab sheet 1
-I will have respective fields filled in N3,03,P3,Q3,R3 respectively ...the macro code will take values from used fed data in this cells of sheet 1 and the entire workbook will get attached and previewed ...once user then prsses send ,it will go !


Basically once the solution is posted ,i will call the subroutine from the already main routine at the end so that mail routine gets called at the last post all other routines have executed and the workbook is completely filled

in short presently the skeleton is like

sub x
call a where a is already developed subroutine for task a
call b where b is already developed subroutine for task b
call c where c is already developed subroutine for task c

end sub

i want to make it

sub x
call a
call b
call c
call d ////where d will be posted solution for subroutine for mailing after attaching the entire workbook taking values from sheet 1 /////


end sub


where d is the sub routine for mail macro


Thanks ,

Amlan Dutta