Microsoft Outlook 2010, Microsoft Office Outlook 2003; In this article Summary. The Outlook Rules Wizard allows you to 'run a script' when you create a specific rule. As a developer, this allows you to perform an action on incoming mail that is not possible using the regular features of the Rules Wizard. More Information. Access and Outlook both work, but I cannot get the “Import Exchange/Outlook Wizard” to work in Access 2013. When I click External Data tab Import & Link More Outlook folder, the first Wizard screen appears but nothing happens after clicking OK button. So far I have tried a “Quick Repair” and an “Online Repair” of Office 2013. Outlook Import Wizard. Outlook Import Wizard works as eml to pst and msg to pst converter featuring built-in module for primary integrity check. It allows importing not only messages, but also attached files. And on top of it all, Outlook Import Wizard allows preserving folder structure while importing e-mails, which is particularly convenient for importing backups. The Import and Export Wizard of Outlook 2013 and Outlook 2016 has indeed been “cleaned up” by removing some old or redundant file formats. This included the Excel option as well. Even though the xlsx-format has been the standard since Office 2003, the Import and Export Wizard still only supported the old xls-format.
-->Summary
The Outlook Rules Wizard allows you to 'run a script' when you create a specific rule. As a developer, this allows you to perform an action on incoming mail that is not possible using the regular features of the Rules Wizard.
More Information
Important
Although the Rules Wizard refers to the custom code as 'script,' you must create the code in Outlook Visual Basic for Applications, not in Microsoft Visual Basic Scripting Edition (VBScript) or other scripting languages such as Microsoft JScript. Also, Outlook Visual Basic for Applications is not designed to be deployed, so deployment of this custom code requires manual configuration on each user's computer. You cannot create the custom code in an Outlook COM Add-in. For additional information about limitations related to distributing Visual Basic for Applications projects, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Outlook Import Wizard Microsoft Excel
290779 Description of managing and distributing Outlook 2002 Visual Basic for Applications (VBA) projects
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services.
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site: Microsoft Support
![Outlook Import Wizard Microsoft Outlook Import Wizard Microsoft](/uploads/1/2/5/0/125006734/737838563.png)
To implement the custom code to process the message, create a subroutine in Visual Basic for Applications. The name of the subroutine does not matter, but it must accept one argument because the Rules Wizard will pass a mail message (MailItem) or meeting request (MeetingItem) to the subroutine. The argument must by of type MailItem or MeetingItem, otherwise the subroutine will not be available in the Rules Wizard. You cannot create one subroutine to handle both types of items by defining the argument to be of type Object. The following Outlook Visual Basic for Applications code illustrates how to create the subroutines:
You can put the subroutine in any module, including ThisOutlookSession, but if you move the subroutine to another module or change the subroutine's name, you must modify the rule to point to the updated subroutine.
Outlook has an Import/Export wizard that makes it easy to import contacts from a CSV file.
Newer versionsOffice 2010Outlook on the web
- At the top of your Outlook 2013 or 2016 ribbon, choose File.If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2016 or 2013. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.
- Choose Open & Export > Import/Export. This starts the wizard!
- Choose Import from another program or file, and then choose Next.
- Choose Comma Separated Values, and then choose Next.
- In the Import a File box, browse to your contacts file, and then double-click to select it.
- Choose one of the following to specify how you want Outlook to handle duplicate contacts:
- Replace duplicates with items imported If a contact is already in Outlook and your contacts file, Outlook discards the info it has for that contact and uses the info from your contacts file. You should choose this option if the contact info in your contacts file is more complete or more current than the contact info in Outlook.
- Allow duplicates to be created If a contact is in Outlook and your contacts file, Outlook creates duplicate contacts, one with the original Outlook info and one with the info imported from your contacts file. You can combine info for those people later to eliminate duplicate contacts. This is the default option.
- Do not import duplicate items If a contact is in Outlook and your contacts file, Outlook keeps the info it has for that contact and discards the info from your contacts file. You should choose this option if the contact info in Outlook is more complete or more current than the info in your contacts file.
- Click Next.
- In the Select a destination folder box, scroll to the top if needed and select the Contacts folder > Next. If you have multiple email accounts, choose the Contacts folder that's under the email account you want to be associated with the contacts.
- Choose Finish.Outlook begins importing your contacts immediately. You'll know it's finished when the Import Progress box closes.
- To see your contacts, at the bottom of Outlook, choose the People icon.
- At the top of your Outlook ribbon, choose the File tab.If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2010. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.
- Choose Open > Import. This starts the wizard!
- In the Import and Export Wizard, click Import from another program or file, and the click Next.
- To import a CSV file, choose Comma Separated Values (Windows).
- Choose Browse, then choose the .csv file you want to import, and choose Next.Notes:
- Under Options, if you want the imported information to replace duplicate items already in Outlook, choose that. Otherwise, choose Do not import duplicates.
- Set the options for importing items. Choose Filter if you want to only import certain emails. Choose the More Choices tab if you want to only import emails that are read or unread.The default settings usually don’t need to be changed. The top folder — usually Personal Folders, Outlook Data File, or your email address — is selected automatically.
- Shadowhunters episode 3 free. Include subfolders is selected by default. All folders under the folder selected will be imported.
- The default selection of Import items into the same folder in matches the folders from the imported file to the folders in Outlook. If a folder doesn’t exist in Outlook, it will be created.
- Choose Finish. Outlook starts importing your data immediately. You'll know it's finished when the progress box closes.
- To view your contacts, at the bottom of the Outlook navigation bar, choose Contacts.
Use a comma separated values file (CSV) to import your contacts into your Outlook on the web account.
Tip: For best results, make sure that the CSV file has UTF-8 encoding. This encoding works for all languages and alphabets.
- At the bottom of the page, select to go to the People page.
- On the toolbar, select Manage > Import contacts.
- Select Browse, choose your CSV file, and then select Open.
- Select Import.
Note: If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly. The import tool will then show you some example contacts from your file, and you can check that the text is readable and correct. If the text is not displayed correctly, select Cancel. You will need a file in UTF-8 encoding to continue. Convert your CSV file to use UTF-8 encoding, and restart the import. To learn more about UTF-8 encoding, see Why should I care about UTF-8 encoding?
![Microsoft Microsoft](/uploads/1/2/5/0/125006734/218252893.png)
Why should I care about UTF-8 encoding?
Typically, you can import contacts without worrying about the underlying details of how the text is stored in the CSV file. However, if the contact information includes characters not found in the English alphabet, such as Greek, Cyrillic, Arabic, or Japanese characters, this can cause problems when importing contacts. Therefore, you should save the contacts file with UTF-8 encoding if you have that option during export.
If you can't export your contacts using UTF-8 directly, you can convert the exported CSV file using Excel or third-party apps. How to do this will be different between apps and app versions.
Outlook Import Wizard Microsoft Email
How to convert your CSV file to UTF-8 using Microsoft Excel 2016:
- In Excel, create a new blank document (workbook).
- From the Data menu, select From Text/CSV. Browse to your exported CSV file (you may have to select to display Text Files (..csv) to see it). Select Import.
- In the dialog box that appears, under File Origin, choose the encoding that makes the characters in the text appear correctly, for example, Cyrillic Windows 1251, and then select Load.
- Check that characters are displayed correctly in Excel.
- Select File >Save As. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type.
- Select Save.
Didn't work?
See Fix problems importing contacts to Outlook.