How can save Emails in Outlook Draft

2 views
Skip to first unread message

Ashish Kumar

unread,
May 14, 2015, 5:51:35 AM5/14/15
to Excel...@googlegroups.com
Dear Group Members,

If you need to save all emails in Outlook Drafts & and check all emails before send to the clients, then use this file.


Regards
Ashish Kumar

For Khagesh.xlsb

khagesh khera

unread,
May 14, 2015, 6:17:09 AM5/14/15
to Excel...@googlegroups.com
Dear Ashish,

Thanks it is helping out but i have to mentioned some text on body which is enclosed. Also can i attached any excel or PDF file with the email.

Regards,
Khagesh

Ashish Kumar

unread,
May 14, 2015, 6:31:16 AM5/14/15
to Excel VBA Lab
Dear Khagesh,

Yes, It's Possible. You can attach any file.

Go in VBA Module 1 

Paste your file path for send file as per your requirement
And, Change text also.


Regards
Ashish Kumar

khagesh khera

unread,
May 14, 2015, 6:48:44 AM5/14/15
to Excel...@googlegroups.com
Hello,

Thanks but i can't getting it done when the file had different names. I have many invoices for many clients with different invocie no. but in every email he is picking the same invocie.

Also can you help in selecting a range from any excel file to get them pasted on body of email.

Regards,
Khagesh

Ashish Kumar

unread,
May 14, 2015, 6:52:17 AM5/14/15
to Excel VBA Lab
Ok, First you send the text which you want to paste in Mail body.


Regards
Ashish Kumar

khagesh khera

unread,
May 14, 2015, 7:04:40 AM5/14/15
to Excel...@googlegroups.com
Hi,

Please find enclosed the text. If required we will share the copy of email we sent to clients.
Email.txt

Ashish Kumar

unread,
May 14, 2015, 7:23:59 AM5/14/15
to Excel VBA Lab
Hi Khagesh,

Share the Subject Line.


Regards
Ashish Kumar

khagesh khera

unread,
May 14, 2015, 7:26:35 AM5/14/15
to Excel...@googlegroups.com
Hi Ashish,

Intertek Outstanding details - April'15

Ashish Kumar

unread,
May 14, 2015, 7:50:56 AM5/14/15
to Excel VBA Lab
Hi Khagesh,

PFA....!!

You Need to paste file path in L column and HIT the Blue Button.


Regards
Ashish Kumra

Save Emails in Draft.xlsm

Ashu K

unread,
May 14, 2015, 10:51:15 AM5/14/15
to Excel...@googlegroups.com
Dear Ashish Sir,

Excellent Work....!!

Superb Solution :)


Thanks & Regards
Ashu Kenith
Reply all
Reply to author
Forward
0 new messages