SendTo = vaRecipient
.Subject = stSubject
.Body = vaMsg
.SaveMessageOnSend = True
End With
'Send the e-mail.
With noDocument
.PostedDate = Now()
.Send 0, vaRecipient
End With
'Release objects from the memory.
Set EmbedObject = Nothing
Set obAttachment = No
ned the separator as "-" change it based
> on your data separator.
>
> I have attached my sample solution file for your easy reference.
>
>
> Hope that helps!
>
> ---
> *Sixthsense
> **:) Man of Extreme & Innovative Thoughts :)*
>
>
> On Sun, May 29,
mp; Innovative Thoughts :)
>
> *
>
> On Fri, May 27, 2011 at 9:50 AM, Bharghav Ramdas wrote:
>
>> Hi All,
>>
>> Looking forward to your reponses.
>>
>> Rgds,
>> Bharghav Ramdas
>> On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas wrote:
>
Hi All,
Looking forward to your reponses.
Rgds,
Bharghav Ramdas
On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas wrote:
> Hi All,
>
> I am currently working on an excel (2003)sheet whose cell character length
> is beyond 255. I am able to copy just 255 characters. The remaining
>
Hi All,
I am currently working on an excel (2003)sheet whose cell character length
is beyond 255. I am able to copy just 255 characters. The remaining
characters get truncated.Your help in this regard will be very much
appreciated.
Example
cell character length =300.
While pasting or doing any c
ative result.
>
> If you don't CARE about the sign, then you can use:
> =ABS(A1-A2)
> and format it as "time" to get: 0:30
>
> If you DO care about the sign, then you need to change the display format
> to a numeric format.
>
> Paul
>
>
> *Fro
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
###.How do I go about resolving this issue.I require a positive number 0:30
inspite of the result turning out to be negative.
FYI
=(1-2)
Current Expecting
19:309:30
210:00 10:00
t;<><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subsc