How to Auto forward Emails from Outlook to SharePoint Document Library:

Before in My earlier Organization, we wanted to auto forward outlook emails to one of SharePoint document library. I followed the below steps to achieve this.

Ø  Make sure Target Doc Lib contains Email address and it’s working

Ø  Then go to Outlook and click on New > Contact

Ø  Add Email address of that document library into the Outlook Contacts.

Ø  Save it and now create a rule from Outlook > Tools > Rules and Alerts > New Rule

Ø  Select “Start from a blank rule” option.

Ø  Select Check messages when they arrive > Next

Ø  Select “Condition” for which you want to forward emails to Doc Lib in step 2.

Ø  Then select action “forwards it to people or distribution list” and click on people or distribution list

Ø  Select “Outlook Address book” from Address Book drop down and you will getSharePoint Document Library email address as a contact > Add it

Ø  Click on Next > Finish

   Ø  Now send an email with that condition to check rule.

Please Comment if you need any Assistance.

Export a Discussion topic List item (SharePoint 2007) to excel or PDF

Here is  some  ways  to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

                       Open Excel
·         Click on DATA tab
·         Select from Web option
·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx
·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to        insert required data to excel.
·         And from Excel you can easily export to PDF

Path for the Host File

I posted this very simple, because many times when I work on SharePoint. I forgot the path for Host Entry to check .So, Useful for the Bees who are same like me some times!!!!

Path : C:\Windows\System32\Drivers\etc\hosts

Post Setup(PSConfig)Configuration of SharePoint Products and Technologies failed

While Running PSconfig, Its failed in Any step.

Please follow the below Steps to fix the issue.

 Fix 1:

Copy the web.config file from: C:\ProgramFiles\CommonFiles\MicrosoftShared\WebServer         Extensions\12\CONFIG To: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS.

  Then run: psconfig -cmd upgrade -inplace b2b –wait  –force 

Upon re-running the configuration wizard via command line, my upgraded succeeded and returned. Run the PSConfig Wizard and check for Success of it.

Note: Delete web.config from C:\ProgramFiles\CommonFiles\MicrosoftShared\WebServer Extensions\12\TEMPLATE\LAYOUTS.

    Fix2 :

Rename the DSN in the registry to DSN.old

Path :HKLM > Software > Microsoft > Shared Tools > Web Server extensions > 12 > Secure > ConfigDB > DSN

Note: The path For SharePoint 2010 is below

Path :HKLM > Software > Microsoft > Shared Tools > Web Server extensions > 14.0 > Secure > ConfigDB > DSN
        
       

Once the DSN is renamed, Run the PSCONFIG Wizard again.

Note: Please consider the customizations while running this step in Production.

Execution policy Error Running Scripts Within Windows Power Shell

 Error While Running the Script In Power shell

Cause: The execution policy is determined by execution policies that you set by using Set-ExecutionPolicy and the Group Policy settings for the Windows PowerShell execution policy. The default

value is "Restricted."

Resolution: Run the below command to Run\Execute the command in power shell.

This command gets the current execution policy for the computer.

·  Get-ExecutionPolicy

These commands set a new user preference for the execution policy and then display the effective execution policy

·  Set-ExecutionPolicy RemoteSigned