Yes... point 3.. It should be all of the attachments.
Currently i am using below code. Where i need to enter the code manually.
>>> use code - tags <<<
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
If (TypeOf Item Is MailItem) Then
Dim strMsg As String
Dim...
Hi,
I sent out lot of emails in a day and chances of attaching wrong attachment to wrong code is very high.
I am looking for an Prompt msg in Outlook when we hit on send by matching 6 digit code in the subject line with the name of the attachments. If the code in subject line does not match...
Hi,
I have created NIGO template in excel to paste the selected NIGO reasons in msWord(NIGO_Template) after 2nd paragraph. things are fine till here
I am looking for a VBA form in msWord (NIGO_Template) itself. I want all the NIGO reasons as a check points in the form, which ever is selected...
Thank you so much for your input.. its actually a Template and Saving the workbook in all the folder is our job... People will go to each folder and take it forward from there.
Hi,
I have a workbook named "2020Help". I need to save this file in almost 2000+ folders. folder name is not unique but the subfolder name is "2020help".
is there a way to search the sub folder name and save the file in it.
Any help will be greatly appreciated
Under the Sheet name “MO.Individual Training Tracker” Column A has task type and Row # 2 has employee names.. And their training status Trained (TR) Not Trained (NT).
Based on the Trained (TR) status, Column F in Sheet “MOWorkAllocation” should update.
I have updated the expected result in...
Could you please run the macro.. After running the Macro, Under 'MO.DailyAttendace' Sheet you will see the staff names in column F. Allocation in column F is not happening properly..
Thank you for your time..
"MO_AmeritasWorkAllocation" file already has a VBA which is pulling 'task ID', 'Task Type', 'Action Step' & 'Workbasket' from "realtime_sla_role.xls.xlsx" file... Then allocating the tasks to the User ID's (Which is in "MO_AmeritasWorkAllocation" file under "MO.Daily...
Hi,
I am creating Macro to allocate the work to team members. I have created a VBA however there is some issue with the looping.
In the sheet 'MO.Individual Training Tracker' i have stored all the task types, employee name and there training status. Whenever VBA is allocating the tasks it is...
People work on different engagements which need not to capture in this tracker... This tracker will be specifically used for one set of work.
Make selections and press start… Start working
After ‘duty’ is done.. they may start different engagement so it’s better to stop the work come back...
SAVE button should be changed to Start and End Button.
Once a START button pressed then the time should start and once we Press END button it should stop the time.
Yes the information which is on form is enough.
I feel entering date manually will be fine bcoz we work in night shift which means login @ 05:00PM and logout @ 02:AM.
How about giving a space in the 'form' to enter the time manually by the people.
Yes, Each person will use own file and'master' fill should pull data from those 10 files
As of now we dont have any tracking mechanism to capture the accurate time. With this tracker we need to capture the time for each task. Data in 'Monthly time' is blindly added to match 480 mins/day
If its the question of mismatching in number from Daily Volume to monthly Volume please ignore.. As its a manual data things are captured and reported very badly.