Send Multiple E-Mail With Multiple Attachments And Save To Sent Folder

office version 2007
i can use this coding & this coding is good work
but not full sucessful

i want more editing in this coding

given excel sheet i can paste data ex.

i have only some problem face use this coding, i.e.

1. my mess to long & not set in this column set by "message" column i want my mess attached through word doc file i.e. d:\test\test.doc

2. mail sent & copy save in sent folder

also another coding required in same format but codition some change

1. mutliple emails address to
2. subject all emails same
3. mess all emails same
4. also one/multiple files attached same
5. sent emails automatically & copy save in sent folder

Sonu, what you've asked for is possible. In your word document, can you confirm that it will only contain plain text, and not any other objects like chart, picture etc.

only cantain plain text but some time 2 -3 cloumn add
and not any other objects like chart, picture etc.
if not possible its ok
then only plain text
but mails send & save in sent folder plain text mess long given exmple jpg sheet attached

and i have also one more coding file in same matter
subject ok
mess ok but long prossure
attachment coding not given only mails create send one by one & this coding use only plain text mess & was also delete some column in this sheet because i m not make clomun in mess sheet & i was not findout website

i m check different website
then find some coding but i don't know how to use this coding
Excel Macro VBA - Send Emails through Outlook using Email Addresses from Excel and text from Word - Free Excel Macros VBA - TeachExcel.com

thanks 4 reply