You will not find customised code as per your requirement anywhere. You
have to make changes on your own.
The above link will tell you how to zip one file and then combine it with
mail macro to send that file
Regards
Ashsh
On Thu, Feb 6, 2014 at 5:39 PM, Atul Kesaria wrote:
> Hi Ashish,
>
> W
Hi Ashish,
What I am looking at zipping respective PDF file as a seperate zip file and
not all pdf files in one zip. Sorry but i could not see that in that link.
Regards
Atul
On Thu, Feb 6, 2014 at 12:56 PM, ashish koul wrote:
> check this
> http://www.rondebruin.nl/win/s7/win001.htm
> http:/
check this
http://www.rondebruin.nl/win/s7/win001.htm
http://www.rondebruin.nl/win/section7.htm
On Tue, Feb 4, 2014 at 8:31 PM, Atul Kesaria wrote:
> Hi Ashish,
>
> One more help to earlier macro. Is there a way we can put password to the
> PDF file or make a zip file of respective pdf file wit
Hi Ashish,
One more help to earlier macro. Is there a way we can put password to the
PDF file or make a zip file of respective pdf file with a password and then
email. Password can be predefined to either date of birth or anything else
which would be incorporated in the excel file.
Regards
Atul
Thanks Ashishreally helpfull...
On Mon, Feb 3, 2014 at 10:50 AM, ashish koul wrote:
> try this
>
> Set Mailrng = Sheets("Sheet1").Range("c2:c" &
> Sheets("Sheet1").Range("c1").End(xlDown).Row)
>
>
> On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria wrote:
>
>> Hi Ashish,
>>
>> You are rockstar.
try this
Set Mailrng = Sheets("Sheet1").Range("c2:c" &
Sheets("Sheet1").Range("c1").End(xlDown).Row)
On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria wrote:
> Hi Ashish,
>
> You are rockstar. Just one last help. Can the range be set a dynamic
> rather than staticas the range will vary from tim
Hi Ashish,
You are rockstar. Just one last help. Can the range be set a dynamic rather
than staticas the range will vary from time to time.
Regards
Atul
On Sun, Feb 2, 2014 at 9:50 PM, ashish koul wrote:
> Sub test()
>
> Dim mailrng As Range
> Dim cl As Range
> Dim fl_path As String
>
>
>
Sub test()
Dim mailrng As Range
Dim cl As Range
Dim fl_path As String
Set mailrng = Sheets("Sheet1").Range("c2:c5")
For Each cl In mailrng
Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1))
Next
End Sub
Sub sendmail(mailid As String, nm As String, flname As String)
Dim OutAp
Hi Team,
Any luck of my earlier mail.
Regards
Atul
On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria wrote:
> Hi
> PFA fileplease note that the attachment which need to go with each
> mail would be a PDF file.
>
>
> On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria wrote:
>
>> PFA
>>
>>
>> On Sat,
Hi
PFA fileplease note that the attachment which need to go with each mail
would be a PDF file.
On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria wrote:
> PFA
>
>
> On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote:
>
>> please share a sample file
>>
>>
>> On Sat, Feb 1, 2014 at 5:19 PM, Atul K
PFA
On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote:
> please share a sample file
>
>
> On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote:
>
>> Hi Team,
>>
>> I need a help in getting a macro which will help sending email with
>> attachment to list of person in the excel sheet which will hav
please share a sample file
On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote:
> Hi Team,
>
> I need a help in getting a macro which will help sending email with
> attachment to list of person in the excel sheet which will have there Name,
> email ID,Unique number. Please note that every person
Hi Team,
I need a help in getting a macro which will help sending email with
attachment to list of person in the excel sheet which will have there Name,
email ID,Unique number. Please note that every person should receive a
particular file based on their unique number. File are prestored in a
part
13 matches
Mail list logo
