ADP - IE closes when printing

Solution:

1. IE Tools | Compatibility View Settings, add ADP site.
2. IE Tools | Internet Options | Browsing History | Settings, change 'Disk space to use' into 256.
3. IE Tools | Internet Options | Security, change it to lowest.
4. IE Tools | Internet Options | Advanced, set to default.

Do not change printer set up within ADP. Always change it in Start | Printers | Printer Preferences.

How to crop a video?

Use Adobe Media Encoder (it is automatically installed when you install Adobe CS or Adobe Premiere).

Or within Adobe Premiere, after editing, when you do Export, you will see 'Export Settings' (when Adobe Media Encoder is actually called). There is a crop tool near the top-left corner.

Automatically Map Network Drives on Domain Login for All Users, Certain Users, or Certain Groups

Automatically Map Network Drives on Domain Login for All Users, Certain Users, or Certain Groups

https://tinyapps.org/docs/auto_map_network_drives.html

tinyapps.org / docs / Automatically Map Network Drives on Domain Login for All Users, Certain Users, or Certain Groups

---

As always, use the following instructions at your own risk (and joy). Please submit any corrections or comments if you feel so moved.
Auto map network drives on login for all users

1. Save the following batch file to the domain controller's NETLOGON share as logon.bat:
   @echo off
   net use * /delete /yes
   net use x: \\server_name\shared_directory_name
2. Active Directory Users and Computers
3. Right click domain name at top left and click Properties > Group Policy > Edit > User Configuration > Windows Settings > Scripts (Logon/Logoff) > Logon > Add...
4. Enter path to logon.bat (e.g., \\ACME.local\sysvol\ACME.local\scripts\logon.bat) and click OK three times
5. Login from workstation. Drive x: should appear in My Computer.

Auto map network drives on login for certain users:

1. Save the following batch file to the domain controller's NETLOGON share as logon.bat:
   @echo off
   net use * /delete /yes
   net use x: \\file_server_name\shared_directory_name
2. Active Directory Users and Computers > Users > Double click user > Profile
3. Enter "logon.bat" (no quotes) in the "Logon script" box and click OK
4. Login from workstation as user modified in step 2. Drive x: should appear in My Computer.

Auto map network drives on login based on Group membership

1. Get KiXtart
2. Put WKIX32.EXE in both the domain controller's NETLOGON share and %SystemRoot% (normally C:\WINNT\).
3. Save the following script as map_drive.kx to the NETLOGON share (be sure to change the group as needed - here we've used Domain Users):
   use "*" /DELETE
   if ingroup("Domain Users")
   use x: "\\server_name\share_name"
   endif
4. Save the following batch file (which calls your KiXtart script) as login.bat to the domain controller's NETLOGON share:
   @echo off
   \\server_name\NETLOGON\WKIX32.EXE \\server_name\NETLOGON\map_drive.kx
5. Active Directory Users and Computers
6. Right click domain name at top left and click Properties > Group Policy > Edit > User Configuration > Windows Settings > Scripts (Logon/Logoff) > Logon > Add...
7. Enter path to login.bat (e.g., \\ACME.local\sysvol\ACME.local\scripts\login.bat) and click OK three times
8. Login from workstation as a user belonging to group designated in map_drive.kx. Drive x: should appear in My Computer.
9. If x: does not appear, check the permissions of NETLOGON, WKIX32.EXE, your script files, etc. Also, make sure that the user or group has the necessary permissions on the shared folder you are mapping.

More KiXtart Examples

1. Map drive if user is *not* a member of a certain group (in this case, "Students"):

   If InGroup("Students") = 0
      Use R: "\\server\records"
   EndIf
   

2. Using Boolean operators:

   If InGroup("Teachers") Or InGroup("Office") Or InGroup("PTA")
      Use G: "\\server\Grownup_Files"
   EndIf
   
   If InGroup("2008 Class") And InGroup("Honors")
      Use S: "\\server\smart_kids"
   EndIf
   

3. Using Select...EndSelect (stops processing on the first true Case)

   Select
      Case InGroup("Students")
         Use S: "\\server\student_storage"
      Case InGroup("Office")
         Use O: "\\server\office_docs"
         Use R: "\\server\records"
      Case InGroup("Teachers")
         Use O: "\\server\office_docs"
         Use S: "\\server\student_storage"
         Use T: "\\server\teaching_materials"
   EndSelect
   

---

last update: 2008.02.12

Email message in Outlook is plain text (or not see images) instead of html

Tools | Trust Centre | Email Security | Read as Plain Text,
Clear the tick in front of 'Read all standard mail in plain text'.

How to sum data from different Excel sheets?

It is referred to as to consolidate data from multiple sheets into a master sheet.

1. Drag your mouse to select the cells corresponding to those in multiple sheets. Note: It would not work if you click the top-left corner box.
2. Date | Consolidate.
3. Click the icon under 'Reference'.
4. Go to the first data sheet, and drag-select all the cells. Click the icon again. Click 'Add'.
5. Go to the second data sheet, and repeat Step 4. Repeat until all the data sheets are done.
6. Click OK.

Done.

In addition to 'Addition', you can also do average, counting, max, min, product, etc.

Chrome - In Outlook Web App, can not attach files when composing a new email

There are two solutions -

1. Checking 'Use the light version of Outlook Web App' when signing in. Will be able to attach files.

2.

http://www.c7solutions.com/2014/09/group-policy-import-to-fix-google-chrome-v37-issues-with-exchange-server-and-microsoft-crm

A recent update to Google Chrome (37.0.2062.120) removed the ability to support modal dialog boxes. This are dialogs that require your attention and stop you going back to the previous page until you have completed the info required – these are very useful in workflow type scenarios.
Google claim that as 0.004% of web sites use them (from Google anonymous statistics gathering that you can opt into in Chrome) they are justified in removing support for them – but they have not removed other things that have the same level of support!
With this version of Chrome (or the Chromium open source browser) there is a work around until April 30th 2015 that will allow modal dialogs to work again. Without this work around clicking links in OWA and ECP in Exchange 2010 and OWA and EAC in Exchange Online and Exchange 2013 will not popup. This can cause issues such as the inability to attach files in OWA and to create objects in ECP/EAC for the administrator. Popups in Microsoft CRM also do not work.
As a work around you could use a different browser, but if Chrome works for you (or does not in this case) and you are joined to a domain then you can download the following GPO export file and import it into your Active Directory to enable modal dialogs to work again in Exchange Server, Office 365 and Microsoft CRM products.
To download and import this GPO file to enable Chrome modal dialog box functionality to resume (until 30th April 2015, when Google stop allowing the work around) follow these steps:

1. Download Google Chrome Show Modal Dialog Before 30 April 2015.zip
2. Copy to a domain controller and expand the zip file. Ensure the contents of the zip file are not placed directly on your desktop as you cannot import from the desktop directly, so if you expand the zip to the desktop then copy the one folder that was created into a new subfolder.
3. Start Group Policy Management MMC admin tool.
4. Expand Forest > Domain > Your Domain > Group Policy Objects.
5. Right click “Group Policy Objects” and choose New
6. Create a new GPO called “Chrome and Chromium Modal Dialog Box Allow”:
   
7. Right click “Chrome and Chromium Modal Dialog Box Allow” GPO that you just made and choose Import Settings
8. Proceed through the import wizard. You do not need to backup this new GPO on the second page of the dialog as the new GPO is empty.
9. On the third page of the wizard browse to the parent folder containing the contents of the download above:
   
10. Click Next and you should see one backed up GPO listed:
    
11. Click Next to import this. If you click View Settings first a web page will open showing you that this GPO sets two registry keys for the computer and two registry keys for the user. These set SOFTWARE\Policies\Chromium\EnableDeprecatedWebPlatformFeatures and Software\Policies\Google\Chrome\EnableDeprecatedWebPlatformFeatures (for both Chromium and Chrome browsers) with a reg key (type string) 1:ShowModalDialog_EffectiveUntil20150430
12. Proceed with Next and then Finish and the import will begin:
    
13. Click OK.
14. Now link the GPO object to the root of your domain so it impacts all users and to the root of any OU that blocks inheritance. Import to other domains as above or link from this domain depending upon your current policy for managing GPO cross domains.
15. Delete the zip and folder you downloaded. They are not needed any more.

How to copy Chinese and English texts from a photo PDF file?

Adobe Acrobat
Tools | Text Recognition | In this file | Edit | Priamary OCR Language,

Choose Chinese, then English will also be OK.