Akash kothari
Member
Hello Friend,
In the attached file i have try to build a Macro to send automatic mail.
Based on Column C (Triger). Means if it says "Yes" Then only mail should go out. else it should skip and move to next row(report).
Column E = are the Multiple receiver seperated by (; )
Column F = CC Multiple seperated by (; )
Column G = BCC seperated by (; )
Column H = Subject line of Mail should be copied for each report seperately
Column I = Body of the Mail
Column J = Error desciption whether mail sent successfully or failed
From column K to P are the File names and File path for the attachment.
in the End signature should also be added which is available in outlook.
I have built the incomplete macro not which may not be proper as of now its sending mail but not as per my requirement above.
Please
Thank you
Akash
In the attached file i have try to build a Macro to send automatic mail.
Based on Column C (Triger). Means if it says "Yes" Then only mail should go out. else it should skip and move to next row(report).
Column E = are the Multiple receiver seperated by (; )
Column F = CC Multiple seperated by (; )
Column G = BCC seperated by (; )
Column H = Subject line of Mail should be copied for each report seperately
Column I = Body of the Mail
Column J = Error desciption whether mail sent successfully or failed
From column K to P are the File names and File path for the attachment.
in the End signature should also be added which is available in outlook.
I have built the incomplete macro not which may not be proper as of now its sending mail but not as per my requirement above.
Please
Thank you
Akash
Last edited: