$$Excel-Macros$$ Sending email from Excel

[gargee singh]

Hello Experts ,

I need help with being able to send email from excel based on a criteria .

As in the excel attached herewith you will see Column D has dates , so if the 
date in column D is today's date (named range in Column L ) ,the email should 
be sent out as per the details mentioned in that specific row , since these 
could be different people.

Email body will be Column C to Column F.

Is it possible to send out emails without opening the excel file each day ?



Regards
Gargee

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


testemail.xlsm
Description: testemail.xlsm

Re: $$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

[Devendra Sahay]

Hey Guys,

Can you please share the files again ? Please.

On Mon, Dec 5, 2016 at 9:35 PM, Chris  wrote:

>
>
>
> *Thank you!You, sir, saved my day (interview tomorrow ;D)*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

With Regards !!!
Devendra

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Looking for SAP CRM- Service Modules

[Reddy Raju]

Hello,

 

*Title: SAP CRM- Service Modules*

 

*Location: Santa Clara, CA*

 

*Duration: Long Term*

 

*Description:*

 

· At least 7 to 9 years of SAP CRM Service consulting experience

· Team member for at least ONE full life cycle SAP PM/CS or SD and 
ONE CRM Service Implementation  

· Support Lead for SAP CRM Service. Address and resolve help desk 
tickets in a timely and efficient manner, providing hands on user support 
as needed 

· Heavy hands on experience with various CRM application areas such 
as: Installed Base, Service Contract/Service order Management/Warranty 
Management/Case management/Interaction Center & RPA /Field Application 
(Mobile)/ Analytics 

· Knowledge of ASAP methodology/SOLMAN & Exposure/knowledge to 
SAP's Best Practices

· Interpersonal skills: strong presentation/ communication / 
facilitation/ leadership skills (oral and written) 

· Ability to work independently, guide clients, understand business 
processes and work cohesively with project / support team members. 

· Design, implement and configure minor to major functionalities in 
SAP CRM Service 

· Willingness to work both in production support and change 
requests / implementations as needed

· CRM Middleware knowledge /exposure is added plus.

· Work with CRM, Supply Chain and Finance data owners to fix data 
issues or to re assign responsibilities

 

*Expertise:*

 

· Hands on experience on latest releases: CRM 7.0 

· Extensive previous CRM Service configuration experience

· Previous implementation experience with semiconductor industries 
is a BIG PLUS

· Prior Big 5 consulting experience 

· Certifications in SAP CRM Service

 

 

*Thanks & Regards,*

*R.Raju*

*Technical Recruiter.*

 

 

 

 

 

 

321 S Main Street, 

Suite # 300, 

Ann Arbor MI - 48104.

   TEL

 

:

734-259-2181 Ext:  426 

   Direct 

 

:

734-224-6628

   Fax

 

:

734-468-0881

   Email  

 

:

raj...@tekwissen.com

   Web   

 

:

www.Tekwissen.com 

   Global

 

:

USA | Dubai | Singapore | India

The information contained in this communication is highly confidential and 
is intended solely for the use of the individual(s) to whom this 
communication is directed. If you are not the intended recipient, you are 
hereby notified that any viewing, copying, disclosure or distribution of 
this information is prohibited. Please notify the sender, by electronic 
mail or telephone, of any unintended receipt and delete the original 
message without making any copies.

*This is not an unsolicited mail. If you are not interested in receiving 
our e-mails, then please reply with “unsubscribe" in the subject line or 
click on following link to be removed from our mailing list **click here* 


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ HELP HELP!!! Error 76 when running a Macro!!! time matters

[Federico Miranda]

Hello, I am receiving the error 76 when running a macro here some of the 
script 


Sub All()

Sheets("Dictionary").Select
Range("B2:B150").Select
Selection.Copy

Sheets("Macro").Select
Range("E11").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False

Range("A1").Select

End Sub

Sub Carga()

'Variables
Dim i, j, n, p, b, w As Integer
Dim Path, qpwd As String
Dim f_exist As Boolean
Const nbl = 5850
Dim File(300), Firm(200), no_firm(200), todel(200)
Dim objFSO, objFile, objFolder
Dim xlBook, wb As New Workbook
Dim XlSheet1, XlSheet2, XlSheet3, XlSheet4 As New Worksheet

w = 2

'On Error Resume Next
Application.DisplayAlerts = False 'Remove excel alerts
Application.DefaultSaveFormat = 51
Namebook = ActiveWorkbook.Name

qpwd = InputBox("Type the password to unlock sheets", "Password")

'Path
Path = Range("G3").Value
If Right(Path, 1) <> "\" Then
 Path = Path & "\"
End If

'Clean
Sheets("Files").Select
Range("A1:B300").Delete

Set wb = ActiveWorkbook

Set objFSO = CreateObject("Scripting.FileSystemObject")
*Set objFolder = objFSO.GetFolder(Path)*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ how to remove password

[Paul Schreiner]

There are services you can obtain (try Googling "excel password recovery")but 
the rules of this forum include:
 3) Don't post questions regarding breaking or bypassing any security 
measure.
(I think the list owners don't want the liability associated with assisting 
someone to bypass the protection on copyrighted material)
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Friday, December 2, 2016 8:54 PM, Izhar  wrote:
 

 I want to unhide the sheets in the attach workbook when I do this a message 
pop up as shown below unable to set the visible property of the worksheet 
classI know it is protected sheets but i dont remeber the password, is there 
any software or macro which can do this.Thanks


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

[Chris]

*Thank you!You, sir, saved my day (interview tomorrow ;D)*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: how to remove password

[oussama sahri]

Hi,

You can found the solution here :

http://www.web-tuto.com/remove-password-vba-project/



2016-12-05 1:53 GMT+00:00 GENIUS :

> sir,
>
> I need your help
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Oussama SAHRI*
+212-659865151
o.sa...@gmail.com
My Resume :http://www.doyoubuzz.com/oussama-sahri
My Links : 


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.