Hi,
I have requirement where i need to copy group of cells in the spreadsheet or excel sheet and paste in Mail. Can anybody help me in this?
I am new to VB, kindly help me out.
rohithcs
Last Activity: Jan 24 '08, 10:32 AM
Joined: Nov 12 '07
Location: India
-
Thanks for your support.
I looked into the article in the mentioned link.
The code works fine, if you know the filename.
what if the filename keeps changing? (Although path remains the same)... -
Here is detail requirement.
Requirement: With cllck of a button. I would like to send a mail and attach the files in a particular folder.
Code:
Private Sub Form_Load()
Dim Olook As Object
Dim Omail As Object
Set Olook = CreateObject("O utlook.Applicat ion")
Set Omail = Olook.CreateIte m(olMailItem)
MailBody = "Hi ,"
Mail1Body = " Find attached...Leave a comment:
-
Thanks for your reply.
I want to automate the upload. The path of the folder is fixed. And I would like to attach all the files in the folder.
Could please help me out?...Last edited by Killer42; Nov 13 '07, 02:30 AM.Leave a comment:
-
How do I attach multiple files to Mail?
I need a piece of code which could attach all the files stored in a folder.
The files in the folder can be *.xls, *.doc or *.pdf. I will be having only the path of the folder and file names in the folder would be dynamic.
Can anyone help me out?
No activity results to display
Leave a comment: