Search:

hi expert thanks for replay, i tried as u suggested, but i m getting
"Compile Error-Method or Data Member not found"
please help me to get it done..........................Thanks in advance.......

Sub emailmergewithattachments()
Dim Source As Document, Maillist As Document, TempDoc As Document
Dim Datarange As Range
Dim i As Long, j As Long
Dim bStarted As Boolean
Dim oOutlookApp As...

I have a situation here.I got 30-40 files.I have to consolidate it.I have used a Following VBA for it:


Private Sub ConcatenateAll()

Workbooks.Add
ChDir "C:\"
ActiveWorkbook.SaveAs...

Thanks for your replay,
I have tested 'ALT+Enter' method also and 'wrap-text method, both doesn't worked.................'
can it possible to add body of the message in the code...

Dear Expert,
Thanks a lot for this macro, really its doing magic. But i need your help to do some changes in this code according to my requirement.
i want body of the message should reflect as...