I domt see .From property defined anywhere. I did try with SendName
property but the code errors out.
Any further help is greatly appreciated.
Dim myMail As MailItem
'All
'my
'code
With myMail
.To = "myn...@myadd.com"
'.From =
.Subject = "My files"
Attach a file in reply to this email..
On Fri, Nov 20, 2009 at 3:55 PM, mahavir wrote:
>
> i dont know how to attached file. pls tell me the procedure
>
> Mahavir
>
>
> On Nov 19, 10:50 pm, mahavir wrote:
> > Pls help
>
> --
>
> --
i dont know how to attached file. pls tell me the procedure
Mahavir
On Nov 19, 10:50 pm, mahavir wrote:
> Pls help
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-
send file
On Sat, Nov 21, 2009 at 7:29 AM, sheetallakho...@gmail.com <
sheetallakho...@gmail.com> wrote:
> Hi Friends,
>
> Is there anyway to remove or crack the VBA password from the an excel
> file. As soon as u double click to open the file. It gives a message
> that Enter password for write a
Hi Mike,
Try this code. It may be quicker. But it won't go to the end of Col B if Col B
has any blank cells. Let me know if this is a problem.
Sub NumColA()
Columns("A:A").Insert Shift:=xlToRight
Range("A1") = 1: Range("A2") = 2
Range("A1:A2").AutoFill Destination:=Range(Cells(1, 1),