After deep appreciation for the work that you give, I need some help, I'm working "work force" in the field "call center" I need excel template that when distributing "breaks" for the agents it will send a message or outlook alert to all Agent in his scheduled breaks time through outlok exchange by entering agent user. Simply I want make an association from excel sheet that contain agent breaks with agent outlook acount and we will make logging box that the agent put his user and specific macro will update his data "Break time" and then alert him by his outlook exchange account in his break time. Is it possible assistance in this work? be very thankful to you
outlook distribution breaks
- Thread starter Afarag
- Start date
ianb
Member
This may assist you if you call this in a spreadsheet. it will email a person with the information they require.
It is a start for you.
Sub Mail_user1()
Dim OutApp As Object
Dim OutMail As Object
Set Source = Nothing
On Error Resume Next
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = "email@????.co.uk"
.CC = ""
.BCC = ""
.Subject = "!!!!"
.Body = "?????& vbNewLine & "" & vbNewLine & "?????& vbNewLine & "?????" & vbNewLine & "" & vbNewLine & "??????." & vbNewLine & "?????
.Attachments.Add Dest.FullName
'.Display
.Send
End With
On Error GoTo 0
' .Close SaveChanges:=False
Set OutMail = Nothing
Set OutApp = Nothing
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
End Sub
It is a start for you.
Sub Mail_user1()
Dim OutApp As Object
Dim OutMail As Object
Set Source = Nothing
On Error Resume Next
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = "email@????.co.uk"
.CC = ""
.BCC = ""
.Subject = "!!!!"
.Body = "?????& vbNewLine & "" & vbNewLine & "?????& vbNewLine & "?????" & vbNewLine & "" & vbNewLine & "??????." & vbNewLine & "?????
.Attachments.Add Dest.FullName
'.Display
.Send
End With
On Error GoTo 0
' .Close SaveChanges:=False
Set OutMail = Nothing
Set OutApp = Nothing
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
End Sub
Dears,
After thanking for your effort i need your help again, When i run your macro i face this error "Compil error: syntax error" with highlight on macro title "Sub Mail_user1()"
Then i need to link "analoge clock macro" to our sheet that contain agent breaks.
I want to upload my Breaks sheet to show how can we work? Can i upload? and how?
i appreciate your great effort
Best Regards
Afarag
After thanking for your effort i need your help again, When i run your macro i face this error "Compil error: syntax error" with highlight on macro title "Sub Mail_user1()"
Then i need to link "analoge clock macro" to our sheet that contain agent breaks.
I want to upload my Breaks sheet to show how can we work? Can i upload? and how?
i appreciate your great effort
Best Regards
Afarag