Hi Team,
Can anyone provide me a macro which can extract the sent items mail details
from Microsoft Outlook 2007
I want the details in excel sheet
& required Details are
Mail Recd from Recd Date recd Time Mail Sent date Mail sent to
Subject Mail sent Date mail sent Time
All details Can
Hello All,
I have merged two macros to avoid sending mail either without "subject" or
without "attachment" via outlook.
My problem is this macro is currently working for "attach" word only & this
should work for other word also like "include", "enclose" also.
I'm not expert of macro but I lear
ooglegroups.com]
On Behalf Of Suyog
Sent: 17 September 2012 4:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro for outlook
Hello All,
I have merged two macros to avoid sending mail either without "subject" or
without "attachment" via outlook.
My
gt;
> *End If*
>
> *End Sub*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Suyog
>
o file(s) attached." & vbNewLine & vbNewLine & "
>> Send anyway?"*
>>
>> * result = MsgBox(strMsg, vbYesNo + vbDefaultButton2, ".::
>> Attachment Missing ::.")*
>>
>> *Cancel = result - 6*
>>
>&g
*If Item.Attachments.Count = 0 Then*
>>>
>>> *strMsg = "Did you mean to attach files?" & vbNewLine*
>>>
>>> *strMsg = strMsg & "You have wrote Attach Or PFA in your
>>> message, but there are no file(s) attache
blnFlag = True*
>>>>
>>>> *End If*
>>>>
>>>> **
>>>>
>>>> *If blnFlag = True Then*
>>>>
>>>> *If Item.Attachments.Count = 0 Then*
>>>>
>>>> *strM