I have vba code to send file with attachment i have similar file attachment Aprompt but i want make difference in attachment through code
if i make attachment two files Apromt.xls Aprompt.xls in single mail but i want give name in end of file name like (CCI-APrompt.xls,ONSITE-APROMPT.XLS) OR (Apromt.xls-CCI),(Apromt.xls-ONSITE)
FIND THE IMAGE OF MY REQUIREMENT
I AM NOT ABLE TO UPLOAD FILE ITS HUGE SIZE I PASTED CODE BELOW
THANKS ALOT
I TRIED THIS
.Attachments.Add "CCI-" & "D:\Documents and Settings\Administrator\Desktop\FORMATOPENCALL\DAILY OPENCALL\ONSITE\Aegis Infoware Pvt. Ltd.xls"
.Attachments.Add "ONSITE-" & "D:\Documents and Settings\Administrator\Desktop\FORMATOPENCALL\DAILY OPENCALL\CCI\Aegis Infoware Pvt. Ltd.xls"
Bookmarks