Changing Default Folder View of New Folders (Outlook 2010)

Posted on by
Reply

You can’t set a default folder view of new folders, but you can apply a view to all folders at once.

Apply Current View To All Folders

By default different folders will have different views in Outlook 2010, however you can apply a single view to all the folders in a single step, without the need to customize each and every folder.

Apply Current View To All Outlook 2010 Folders

To apply a current view to all the folders, go to View tab and click on Change View, from the dropdown list click on Apply Current View to Other Mail Folders.

A new window will popup, just select all the folders you want to apply the current view to and save it.

 

Changing Views Back to Show Messages By Date

Outlook 2010 has a new conversation view enabled by default, though not many people will be comfortable with it, if you are not comfortable with the conversation view, you can easily change it back to the default date view.

Select Date View Outlook 2010

To do that just click on the View tab in the Outlook Window and select Date from the available options.

 

Edit and Manage Views

Views provides users with several options, you can modify them to change which fields are displayed, the type of view and so on.

To edit or manage views, click on View tab and select Manage Views or to directly modify settings for the current view click on the View Settings.

Modify Views Outlook 2010

This should pop up a new window which has several options. You can modify the columns that are displayed, what options should the message be grouped by, sorting order of messages, filtering, conditional formatting and more.

Once you have modified the options click on Ok to save them.

Save Views For Future Usage

Once you have customize the views it may be good practice to save it somewhere, Outlook 2010 offers users with an option to save views.

Save Current View Outlook 2010

To save your views, go to View tab and click on Save Current View as New View, in the window that pops up, enter a name for the view and save it.

Once you have save the view it till appear in the change view options, you can easily click on it to apply your view.

There are many more tips like this to come in the future, we will be covering for all the products, so make sure to check back regularly.

Reminders don’t work on Shared Calendars (Outlook 2010)

Posted on by
Reply

If they open the shared Calendar in their existing email profile they will not get the reminders, however if they create a separate profile for the shared mailbox and open it as the resource mailbox profile they will get the reminders.

You can “Invite” yourself to the calendar event and then you will get a reminder. I would recommend categorizing the event for clarity.

 

VBA Macro to Delete Columns with Specific Values (Excel 2010 CODE)

Posted on by
Reply

Sub delete_columns_with_values()

Dim calcmode As Long
Dim ViewMode As Long
Dim myStrings As Variant
Dim FoundCell As Range
Dim I As Long
Dim myRng As Range
Dim sh As Worksheet
‘We use the ActiveSheet but you can also use Sheets(“MySheet”)
Set sh = ActiveSheet

‘We search in row 1
Set myRng = sh.Range(“1:1″)

‘Add more search strings if you need
myStrings = Array(“search string 1″, “search string 2″)

With sh

‘We select the sheet so we can change the window view
.Select

‘If you are in Page Break Preview Or Page Layout view go
‘back to normal view, we do this for speed
ViewMode = ActiveWindow.View
ActiveWindow.View = xlNormalView

‘Turn off Page Breaks, we do this for speed
.DisplayPageBreaks = False

‘We will search the values in MyRng in this example
With myRng

For I = LBound(myStrings) To UBound(myStrings)
Do
Set FoundCell = myRng.Find(What:=myStrings(I), _
After:=.Cells(.Cells.Count), _
LookIn:=xlFormulas, _
LookAt:=xlPart, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, _
MatchCase:=False)
‘Use xlPart If you want to search in a part of the FoundCell
‘If you use LookIn:=xlValues it will also delete rows with a
‘formula that evaluates to “Ron”
If FoundCell Is Nothing Then
Exit Do
Else
FoundCell.EntireColumn.Delete
End If
Loop
Next I

End With

End With
End Sub

File Sharing Mac OS X Lion and PC Windows 7

Posted on by
Reply

If you want to enable file sharing between OS X Lion and Windows 7 computers then there are some step you need to do first. Follow the steps given below to see how you can share files between OS X Lion and Windows 7 computers.

 

Make sure both Mac and PC are connected with the same network connection.

Steps on Mac OS X Lion

Step-1

Open “System Preferences” from Apple menu

OS X Lion Apple menu

Click on “Sharing” icon from “Internet & Wireless” section

OS X Lion System Preferences

Step-2

Click the Lock icon to unlock if its already Locked, you may need to enter the current logged in user password

Step-3

Now turn the “File Sharing” service On by click on its check-box

File sharing OS X Lion

Step-4

Under “Shared Folders” section select folder that you want to share. If the folder is not in the list Click the + button to add specific folder in the Shared Folder list

Shared folders OS X Lion

Step-5

Under “Users” section select the current logged in user and change the user Rights to “Read & Write” by clicking on tiny arrows. Also change Rights of “Everyone” to “No Access”

User access rights

Step-6

Now Click on “Options” button

File sharing option OS X Lion

Check the “Share files and folders using SMB (Windows)” option

Check the logged in user name Check-box, you need to enter its password, click OK, Click the Done button.

Sharing options OS X Lion

Step-7

Note down the IP address as shown on your Mac.

Mac IP Address

Close the File sharing window on Mac

OS X Lion File sharing

 

Steps on Windows 7

Step-8

Now open Run windows in Windows 7 by pressing Ctrl+R buttons from keyboard

Step-9

Type the IP address of your Mac computer that you have noted down in step-7. Type the IP address in the format as show below and hit the OK button

This will prompt for the Username and Password of the Mac computer. Type the Username that you have selected in step-5 and 6.3 and its Password, hit the OK button

You will see all the shared folders of Mac OS X Lion in Windows 7. Now you can Cut, Copy, Paste or Delete any Mac’s shared files or folders from within Window 7.

If yo want to do the reverse process see how to accees Windows 7 files on OS X Lion

Advanced Motion Paths (PowerPoint 2010 Training)

Posted on by
Reply

PowerPoint 2010:

by AJ George

Using motion paths in PowerPoint is fun, but also kind of complicated. Probably the most complicated aspect of using motion paths is continuing the motion from slide-to-slide. Does this scenario sound familiar? You want an image on your slide to move using a custom motion path. On the next slide you want the image to move from where it ended on the previous slide to a new location. The problem is PowerPoint only shows you where the image begins in the motion path. To line up on the next slide exactly where the image ended is very difficult. As a result, your image can “jump” as you go through your presentation.

The way to avoid this unfortunate “jump” situation is to essentially work backwards.

  1. Create your slide and position the image you are going to animate in its final location (where it will end after the motion path plays).

    In the example below, I want the hand to come up from off of the slide and look as though it is pushing the text “Meet Jackson” up on the screen. On the next slide, I want the hand to continue moving from this position and then exit to the right.

    Meet Jackson

  2. Duplicate this slide ([Ctrl-D]).

    If this slide was your first slide, the duplicate will be your second. After duplicating, return to the first slide.

    Note: Motion paths work from the center of images. Before you continue, you will need to find the center point of the image you will be animating. In this case I will be working with the hand.

  3. Notice the handles around the image. (If you don’t see them, click once on the image.)

    PowerPoint handles

  4. From the View tab, select Guides in the Show area to make the slide’s guides visible.
  5. Drag the guides so they line up with the center and middle handles of the image. The intersection of the guide lines is the center of your image.

    Guides centered

  6. Insert your desired motion path (Animations > Add Animation > Motion Paths).

    For this example I am using a simple Line motion path. Starting at the end point (where your image currently is) and drawing to where you would like the image to begin its motion path.

    Motion path, end-to-start.

  7. Right-click the motion path (not the image) and choose Reverse Path Direction.
  8. If the Animation Pane is not already visible, choose Animations > Animation Pane to view it now.
  9. On the Animation Pane, click the down arrow next to the motion path animation and select Effect Options.

    Notice that my image has a descriptive name of “Hand” on my Animation Pane. If you would like to learn how to do this in PowerPoint, click here.

    Effects options

  10. From the resulting dialog box, click the down arrow next to Path, select Locked and then click OK.

    Path locked

    Locking the motion path will allow you to move to the image without the motion path automatically moving with it.

  11. Select the object you are animating (in this case, the hand) and place your cursor directly over the intersection of the guides (the center of image).
  12. Carefully drag the image so that your cursor (which is in the center of the image) overlaps where the green arrow of the motion path is.
  13. Move to your second slide (where your image appears exactly where it ended on the 1st slide) and add the rest of your animation.

Check out this video to see the completed animation. I used the same method to animate the “Meet Jackson” text.