When printing tables of Outlook emails, you may prefer to print each table in separate pages so as to leave enough empty space for adding lots of notes beside each table later. At present, this article will tell you how to get it intelligently.  

From my previous article “2 Methods to Quickly Print All Tables in Your Outlook Email“, you can get a way to print out tables only in an email. That means would print the tables continuously in one page. In this situation, if later you add a lot of annotations beside the tables, this page will look a bit crowded. Hence, perhaps you will wish to print the tables in separate pages. Now, in the followings, we will share you a smart and effective way to achieve it.Batch Print All Tables of Multiple Outlook Emails

Batch Print All Tables of Multiple Emails

  1. At the very beginning, start Outlook application.
  2. Then, access Outlook VBA editor via “Alt + F11”.
  3. Next, paste the VBA code below into a module.
Sub BatchPrintAllTablesOfMultipleEmailsOnSeparatePages()
    Dim objSelection As Outlook.Selection
    Dim i As Long
    Dim objMail As Outlook.MailItem
    Dim objMailDocument As Object
    Dim objWordApp As Object
    Dim objTable As Object
    Dim objTempDocument As Object
 
    'Get all selected emails
    Set objSelection = Outlook.Application.ActiveExplorer.Selection
 
    If Not (objSelection Is Nothing) Then
       For i = objSelection.Count To 1 Step -1
           If objSelection(i).Class = olMail Then
              Set objMail = objSelection(i)
              Set objMailDocument = objMail.GetInspector.WordEditor
 
              On Error Resume Next
              Set objWordApp = GetObject(, "Word.Application")
              If objWordApp Is Nothing Then
                 Set objWordApp = CreateObject("Word.Application")
              End If
              objWordApp.Visible = True
 
              For Each objTable In objMailDocument.Tables
                  objTable.Range.Copy
 
                  'Print tables in separate pages
                  Set objTempDocument = objWordApp.Documents.Add
                  objTempDocument.Content.Paste
                  objTempDocument.PrintOut
                  objTempDocument.Close False
              Next
          End If
      Next
 
      objWordApp.Quit
    End If
End Sub

VBA Code - Batch Print All Tables of Multiple Emails

  1. After that, add this macro to Quick Access Toolbar according to “How to Run VBA Code in Your Outlook“.
  2. Finally, you can try it.
  • At first, select several emails whose tables you want to print.
  • Subsequently, click the macro button in Quick Access Toolbar.Run Macro on Selected Mails
  • When macro finishes, all the tables of these emails will be printed out in separate pages.Printed Tables

Fire Back Against All Risks around Outlook

Outlook is unable to escape from errors, crash and so on. Therefore, maybe you have met up with some errors or even severe Outlook corruption. Generally, you can firstly try the inbuilt fix utility for Outlook fix. When it fails, you can continue to resort to a more experienced external tool, like DataNumen Outlook Repair. It’s capable of solving majority of Outlook problems with ease.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql corruption and outlook repair software products. For more information visit www.datanumen.com

Be the first to comment
             

This article addresses an effective method using which users can learn to Assign Default Permissions and Change Them in MS Access.

By Assigning default permission on their databases, users can limit and manage the accessibility of their resources. Restricting permission also helps in making your database more secure and manageable. The user can assign permission based on different groups or departments in the company, rather than assigning permission to each user for every object individually. As a new user login to your MS Access, he/she will automatically inherit the permissions, which is assigned to his/her designated group.  Users can assign permission on Forms, Reports, Tables, Queries, and Macros.How To Assign Default Permissions In MS Access

Steps to Learn to Assign Default Permissions

Users can change permission setting for particular Tables, Reports etc or the whole database and make their interface more secure.

  • Assign Permissions In MS AccessStep 1: Open the database containing the Forms, Reports, Tables, Queries, and Macros.
  • Step 2: Select Security from the Tool Menu, > Click on User and Group Permission.
  • Step 3: Select User or Group, from the Permission Tab and then click on the group or user which already has the permission that you wish to assign to the Group/User Name Box.
  • Step 4: Go to Object Type box and select the object type and click on the Object Name list.

The selection will vary depending on the object type selected by the user.

  • Step 5: Now user needs to select the default setting that he/she wishes to assign to the object type and then apply them.
  • Step 6: Repeat step 4 and 5 for assigning default permission for any additional object type.
  • Note: User can only manage the Default Permission of the current database that is open.
  • Step 7: For adding additional groups or users, repeat step 3 to 5 and then finish the process by clicking on Ok.

Steps to Change Assign Default Permissions in MS Access

Users can change default permission, by updating and allowing new groups or users to access the database of a particular category. Users can also allow other users to view data, which has returned from queries or action queries, to run queries, even if their permission is restricted from viewing the query or table in the subject.

This feature comes in handy for a big organization, with loads of data in their system. They can use this method to change and manage Default Permission for their resources allowing users to access the information when required.

  • Step 1: Select Options from the Tools menu.
  • Step 2: Click on Table/Queries Tab.
  • Step 3: Click on Run Permissions that user wants to use.

Things to keep in Mind while Assigning Default Permissions

  • If a user selects Owner’s: All users will have owner’s query permission to run or view the query.

Only query owner is eligible to save change in the query.

Only query owner is eligible to change the ownership rights of the query.

  • If a user selects User’s: Permission granted under the classification of users, will have the permission to use it. And users with Administer permission are eligible to save and make changes in its query. The administering user can also change its ownership.

Users working on MS Access can occasionally come across a corrupted Access file. In case you too ever encounter such a situation, immediately take help of a specialized tool like DataNumen Access Repair.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment
             

Recovery partition is of great importance in that it contains information for system recovery. Some users who realize its significance are wondering if it’s essential to copy it to other storage device. This post will discuss about this question in depth.

Have you ever encountered system crash or corruption? Generally, in such cases, you have to choose either restoring or reinstalling system. In reality, this task can become considerably simple if there is a recovery partition in the computer drive. It can permit you to restore computer to factory settings in just a few minutes.

Is It Necessary to Copy the Recovery Partition to Other Storage Device?

Based on mentioned above, you must have known how important the partition is. Thus, you have to treat it in the same way you handle other partitions that store your valuable data. That is to say, to prepare for system recovery, you ought to copy the recovery partition to other device, such as an external drive. If you still hesitate, please read on. Thereinafter, we’ll show the elaborate principles.

Why:

1. Free up Internal Drive Space

A recovery partition actually holds the image of your original computer state. So, depending on your computer, the partition varies from MBs to GBs. Actually, most of time, it takes up much space on your internal drive. Hence, after copying it to other storage devices, you can remove it from internal drive, which can free up much internal drive space.

2. Protect Recovery Partition

You must have known that backing up data is extremely crucial. For instance, in the event of PST damage, if you have backed up PST files, you can simply recover PST data from backups without needs to repair PST. Actually, the same holds true for recovery partition. Copying the recovery partition to other device is exactly backing it up to protect it exactly.

3. Later Convenient Use

Moreover, if you purchase a new hard drive and intend to replace your old drive, you have to move both system and data from the old one to the new. In this case, if you have copied the recovery partition to external drive, you can get rid of the step of cloning the old drive.

How:

Now that you may have understood the necessity of copying recovery partition to other device, you must wonder the exact methods. Here are 2 ways.

1. Windows Inbuilt Tool

  1. When you create a recovery drive manually, find the “Copy the recovery partition from the PC to the recovery drive” option.
  2. Check it and click “Next”.
  3. Then, insert an external drive, select it and press “Next”.
  4. Finally, hit “Create”.

2. External Tool

If you think that built-in utility is a bit cumbersome, of course, you can resort to a related external tool. As there are such utilities available in today’s market, you can procure one easily. After download it, you can launch it and follow onscreen wizards to complete it.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf fix and outlook repair software products. For more information visit www.datanumen.com

Be the first to comment