Tips On Prepare Excel 2016 Data Source for a Word Mail Merge

You’ve constructed a rundown of contacts and other information that you need to use for a Word mail blend. On the off chance that your information source is a current Excel spreadsheet, at that point you just need to set up the information for a mail combine.

Be that as it may, if your information source is a tab delimited (.txt) or a comma-isolated esteem (.csv) document, you first need to import the information into Excel, and after that set it up for a mail consolidate.

Click here to install office : www.office.com/setup

Stage 1: Set up your information source in Excel

In case you’re now utilizing an Excel spreadsheet as your information hotspot for a mail blend in Word, go to Step 2 in this theme.

On the off chance that the information source is a .txt or a .csv document that contains your Gmail contacts, for instance, utilize the Text Import Wizard to set up your information in Excel.

 

1. Open Excel.

2. On the Data tab, pick Get External Data > From Text.

3. Pick the .txt or .csv document you need, and afterward pick Import.

4. In the Text Import Wizard, in the Original information write sheet, pick Delimited.

5. Select the My information has headers check box over the Preview sheet if the record

you’re bringing in has headers, and after that pick Next.

6. In the Delimiters sheet, select the check box that matches the delimiter your information uses, and after that pick Next.

7. Under Data see, pick the segment that contains ZIP Codes or postal codes, what’s more, under Column information organize, pick Text.

8.Repeat stage 7 as essential, picking the segment you need to change and the information organize you need to apply.

9.Choose Finish.

10. In the Import Data discourse box, acknowledge the default setting of Existing worksheet and the cell address, and after that pick OK.

11. Spare your spreadsheet with another document name.

 

Stage 2: Prepare your information source

 

In your Excel information source that you’ll use for a mailing list in a Word mail consolidate, ensure you design segments of numeric information accurately. Configuration a segment with numbers, for instance, to coordinate a particular class, for example, money.

In the event that you pick rate as a class, know that the rate organization will increase the cell esteem by 100. Organization a section of rates as content in the event that you need to maintain a strategic distance from that augmentation factor.

Additionally, a section that contains ZIP Codes or postal codes should be arranged as content to safeguard the information amid a mail consolidate. Driving zeros—for instance, 00399—in codes are dropped amid a mail blend on the off chance that they’re not designed as content.

Open your Excel information source and pick the segment that contains the ZIP Codes or postal codes.

On the Home tab, in the Number gathering, pick the Number Format (General) box down bolt, and after that pick an alternative in the rundown.

Ensure you include the fitting image previously or after a union field.

 

How to fix Microsoft Office 365 Error Code 30125-4 and 30125-1011

Microsoft office is one of the widely used applications that most of the users have in their systems across the globe. Several versions of Microsoft Office applications are available to the users that are congenial with windows operating system as well as with MAC operating system. You can also access its consolidated features even in your mobile phone by simply downloading the software.
You might see the error with error code 30125-4if your anti-virus software, firewall, proxy settings, or connection prevent you from installing Office. Here are some methods you can try to fix the problem by yourself.

Method 1: Restart your device and Re-install Office
1. Restart your device.
2. Re-install Office application.

Method 2: Use the offline installer for installing Office 365
The Office offline installer may help bypass potential proxy, firewall, antivirus, or Internet connection issues that might occur during an Office 2016 installation

Method 3: Use a wired connection
It is highly recommended to use a wired internet connection in order to bypass any interruption in the network connectivity.

Method 4: Try installing from another location
If you’re trying to install Office 365 at work or at school, the network there may be limited in a way that won’t allow Office to install completely. If this is the case, then it is advisable to take your device home or to a friend’s house, or to a wireless hotspot, so that you have a stable internet connection and then try installing Office 365 again.

Method 5: Temporarily turn off the proxy settings
If you use your device both at home and at work, try turning off the proxy settings in Microsoft Edge or Internet Explorer before you install Office.

In Microsoft Edge:
1. Click on the ‘Start’ button and then select ‘Settings’.
2. Select Network & Internet, go to the bottom of the selections on the left side and click Proxy.
3. In Automatic proxy setup, automatically detect settings or use setup script, by sliding to On or Off.
4. In Manual proxy setup, you can choose to use a proxy server. Generally, it will be off and if you slide it to On, be sure to select Save. And if it was off by default before you turned it on, be sure to slide back to Off when you’ve finished using it.

In Internet Explorer:
1. In Internet Explorer, click Tools (upper-right corner) > Internet options.
2. Click the Connections tab, and then click the LAN settings button.
3. Under Proxy server, clear the option “Use a proxy server for your LAN (These settings will not apply to dial-up or VPN connections).”
4. Click Apply and OK to save changes. Restart your computer.

Method 6: Temporarily turn off the antivirus
1. For temporarily turning off the antivirus go to the settings within the control panel.
2. Select ‘Update and Security’ option and then select ‘Windows Defender’ displayed on the left.
3. Turn the button to Off, and don’t forget to turn it On, as it will make the device prone to virus attacks.

If you are facing any difficulties or challenges in following the above-mentioned steps then just visit office.com/setup for further assistance and support.

Introducing Microsoft Office Setup 2016 On Windows 10

It’s been around two weeks since Microsoft Office 2016 open review for Windows is accessible to download. Office 2016 is a work area suite and unique in relation to the touch-accommodating form of Office for Windows 10.

Microsoft has said that the last form of Office 2016 for Windows would be discharged in the last quarter of the year. Since the general accessibility of Office 2016 is couple of months from now, huge numbers of you should need to investigate the new Office suite for work area immediately.

Office 2016 is good with Windows 7, Windows 8, Windows 8.1 and Windows 10. In this guide, we will indicate how you can introduce Office 2016 Preview on Windows 10. Note that these bearings take a shot at Windows 7 and Windows 8/8.1 too.

Click here to download office 2016: http://www.officeplus.net

Introduce Office 2016 on Windows 10 Step7

Before introducing Office 2016

Before starting to download and introduce on your PC, if you don’t mind uninstall any past variant of Office from your PC as Office 2016 and past Office adaptation can’t be introduced on a similar PC. As such, Office 2016 can’t be introduced on a PC where Office 2010 or Office 2013 is introduced. In the event that you have a past variant of Office, it would be ideal if you take after the given beneath directions to uninstall the past Office establishment.

Stage 1: Type Programs and Features in Start menu look box (Windows 7) and afterward press Enter key to open the same. In case you’re on Windows 8.1/8/7, open Run summon box by at the same time squeezing Windows and R keys, type Appwiz.cpl in the crate and after that press Enter key.

Stage 2: Look for Office 2013 or Office 2010 passage. Right-tap on Office 2013/2010 section, click Uninstall choice and after that take after on-screen guidelines to expel the product. When Office 2010/2013 is uninstalled, if you don’t mind reboot your PC.

Introduce Office 2016 on Windows

Since you have uninstalled past Office establishment, ensure that you have no less than 5 GB of free space on the drive where Windows is introduced. On the off chance that you don’t have adequate free space, if it’s not too much trouble erase superfluous documents and uninstall programs that you don’t utilize any longer to free up some circle space.

Introducing Office 2016 on Windows

Finish the given underneath guidelines to introduce Office 2016 Preview on Windows 10. Office 2016 Preview incorporates Word, Excel, PowerPoint, Publisher, Access, OneNote, and Outlook applications. You can’t pick what applications to introduce amid the establishment.

Stage 1: Visit this page of Office 2016 and download the snap to-run installer for your 32-bit or 64-bit Windows. Make sure to download the correct form of the installer.

Introduce Office 2016

Right now, the disconnected installer or full setup of Office 2016 isn’t accessible. We have to run the downloaded click-to-run installer keeping in mind the end goal to download establishment records and introduce Office applications.

Stage 2: Run the downloaded click-to-run installer to start downloading required establishment records. Once the download is finished, Office 2016 will be naturally introduced out of sight. Amid this time, you can keep utilizing different applications with no issues.

Introduce Office 2016 on Windows 10 Step2

Introduce Office 2016 on Windows 10 Step3

Introduce Office 2016 on Windows 10 Step4

Introduce Office 2016 on Windows 10 Step5

Download office 2016: http://www.officeplus.net/

NOTE: There is no real way to change the default download catalog while introducing Office 2016 Preview. In spite of the fact that the alternative will be accessible in the last form or when the disconnected installer is discharged, there is no such choice in the present see assemble.

When Office 2016 is introduced, you’ll see “Establishment is done” message. That is it!

Stage 3: After finishing the establishment, dispatch any Office application, enter NKGG6-WBPCC-HXWMY-6DQGJ-CPQVG item key when requested to actuate Office 2016 Preview.

Introduce Office 2016 on Windows 10 Step6

Recorded Under: Microsoft Office

Labeled: Office 2016

There is no real way to change the default download registry while introducing Office 2016 Preview. Despite the fact that the alternative will be accessible in the last form or when the disconnected installer is discharged, there is no such choice in the present review fabricate.

Latest Update for Microsoft Office Setup 2016 and Office 2013

Microsoft Office updates are always frequent and as always they have released non-security updates and bug fixes for Office 2013 and Office 2016 on the first Tuesday of the month.

Some most important which caught our attention:

Toward the end of last year, Microsoft was gotten out leaving an unpleasantly defenseless Equation Editor in Office for a long time. Another patch restores the MT Extra textual style so conditions made with the old Equation Editor can be seen.

Another fix refreshes the interpretation of the English expression “forwarding a meeting” for different languages.

As a regular part of an update, windows will install it automatically into Office 2013 and Office 2016.

Here is the brief of new updates:

Microsoft Office 2016 Updates:

KB4018370 MS Office 2016 Language Interface Pack: Improve translation about “forwarding a meeting” in other languages.

KB4022155: Skype for a business update, 2016

  • KB 4294966: Low microphone volume in a call on Lenovo Yoga920 laptop when using Skype for business
  • KB 4294967: For enabling a quicker PSTN call, meeting template updated for Skype for Business 2016
  • KB 4294968: Orange dot without count is shown for a conversation which has no any unread messages in Skype for Business 2016
  • KB 4294969: Outlook stops when making a Skype meeting in Skype for Business 2016 running in a terminal server session
  • KB 4294971: In Citrix-based VDI environment, Skype for Business 2015 and 16 crashes.

KB3178712 Microsoft OneNote 2016:

Following the issue of Microsoft OneNote 2016 are solved in this update:

  • Unexpected deletion of class notebooks.
  • Display of second authentication prompt after doing Pin-based authentication.
  • Video and audio recording are not working properly.
  • Fonts display YuGothic in the wake of changing the default textual style to another DBCS fonts.
  • While opening, editing or closing multiple files, Microsoft OneNote 2018 crashes

KB4022156 Microsoft Office 2016: this update appended the support for $ symbol as a supported delimiter to substitute the | symbol in the UI.displayDialogAsync method and this update also includes decreases latency and consumption for Microsoft Dynamics CRM add-ins.

KB4022158 MS Office 2016: Includes support for a value DisallowWinCredsToBePersisted under the Registry key HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity. Set it to 1 to not allow Security Support Provider Interface (SSPI) credentials to be persisted in Credentials Manager.

KB4022193 MS Office 2016: Enables the display of math equations created with Microsoft Equation Editor 3.0 which is no longer supported. If “MT Extra” is missing in the system, these type of equations will not be displayed. This update installs the “MT Extra” fonts to enable math equations.

KB4011100 Microsoft OneDrive for Business for Office 2016: It adds capabilities to OneDrive to take over the sync relationships of OneDrive for business same like KB3178712 for Office 2013.

Microsoft Office 2013 Updates:

KB4022170: Skype for business 2015 update

KB3178712 MS OneDrive for Business, Office 2013:  The update adds abilities to OneDrive to take over the sync relationships of OneDrive for Business.

KB4022186 Microsoft Word 2013: This update fixes an indent issue when copying table cells from one row to another in Draft view and a crash issue when loading legacy .doc files in Word 2013

  • When one copy a cell of a table in a row and paste it to a table cell in another row in the Draft view in Word 2013, the value of Indent from left is increased by 0.08 in Table Properties
  • When you open a legacy .doc file that’s created by a third-party application in Word 2013, it crashes.

KB4022171 Microsoft Project 2013: The patch repairs a crash problem in Project 2013 while deleting Gannt chart type views that have drawings, a relevant problems that may delete drawings from other views, and when attempting to open enterprise calendars when connected to a Project Web App instance by using Chrome, it solves the error note “Sorry, we were unable to open your project. Please try again. Is this happens again, contact your administrator”.

So, there were the latest updates of Microsoft. They provide very powerful support to their users and always provide frequent updates for solutions of issues.

Microsoft Office Setup Comes to iPhones, Android

How to repair an Microsoft Office Application

Microsoft office is one of the widely used applications that most of the users have in their systems across the globe. Several versions of Microsoft Office applications are available to the users that are congenial with windows operating system as well as with MAC operating system.  You can also access its consolidated features even on your mobile phone by simply downloading the software.

Like any other application, Microsoft Office first needs to be downloaded, installed and activated in order to use this fabulous suit of applications. Many users face certain errors in installing Office Setup and these errors occur due to various numbers of reasons. If an Office application such as Word or Excel isn’t working correctly, sometimes restarting your system will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer. Further, in this article, we will explain how to repair Office Application using your control panel.

  • Steps for repairing Office Application in Windows 10:
  1. Right click on the start button of your computer and then select “Apps and Features” from the popup menu.
  2. Select the Office Application you want to repair and then select “Modify”.
  3. Depending on the copy of the suit installed in your system, either Click-to-run or MSI-Based follow these steps accordingly:
  • If Click-to-run install type then follows these instructions: In How would you like to repair your Office Programs, select Online Repair to make sure everything gets fixed, and then select Repair. (The faster Quick Repair option is also available, but it only detects and then replaces corrupted files.)
  • If MSI-Based install type then follows these instructions: In Change your installation, select Repair and then click Continue.
  1. Follow on screen instructions to complete the repairing.
  • Steps for repairing Office Application in Windows 8 and 8.1:
  1. Right click on the start button and then select “Control Panel” from the popup menu.
  2. Select “Uninstall a program” under “Programs
  3. Right-click the Microsoft Office product you want to repair, and from the drop-down, select Change.
  4. Depending on the copy of the suit installed in your system, either Click-to-run or MSI-Based follow these steps accordingly:
  • If Click-to-run install type then follows these instructions: In How would you like to repair your Office Programs, select Online Repair to make sure everything gets fixed, and then select Repair. (The faster Quick Repair option is also available, but it only detects and then replaces corrupted files.)
  • If MSI-Based install type then follows these instructions: In Change your installation, select Repair and then click Continue.
  1. Follow on screen instructions to complete the repairing.
  • Steps for repairing Office Application in Windows 7 or Windows Vista:
  1. Right click on the start button and then select “Control Panel” from the popup menu.
  2. Select “Uninstall a program” under “Programs
  3. Right-click the Microsoft Office product you want to repair, and from the drop-down, select Change.
  4. Depending on the copy of the suit installed in your system, either Click-to-run or MSI-Based follow these steps accordingly:
  • If Click-to-run install type then follows these instructions: In How would you like to repair your Office Programs, select Online Repair to make sure everything gets fixed, and then select Repair. (The faster Quick Repair option is also available, but it only detects and then replaces corrupted files.)
  • If MSI-Based install type then follows these instructions: In Change your installation, select Repair and then click Continue.
  1. Follow on screen instructions to complete the repairing of Office Application.

If you are facing any difficulties or challenges in following the above mentioned steps for repairing any Office Application then just visit office.com/setup for further assistance and support.

Office Setup | How to Repair Microsoft Office Error code 30145-16?

MS office Error code 30145-16 is basically generated while downloading, installing, upgrading, updating, starting, reinstalling or uninstalling MS office suite’s versions like MS Office 365, MS office 2016 and MS office 2013 shows some significant problems connected with MS Office suite. There are so many causes of this Error code 30145-16 like firewall blocking, Antivirus software conflicting, system file or windows installation issue, or other system conflicting issues.

If you are facing the same error code 30145-16 while working on any MS Office Applications like Word, PowerPoint, Excel, Access, Outlook, Visio, Publisher or any other, then you can solve it by following some of the below steps to resolve Error code 30145-16, and it is the best way to solve it y following this steps in given order only. You can also ask Microsoft team for the support and solutions anytime online using their Email id, phone number or live chat window at office.com/setup.

Solution-1: SFC (System File checking) Scan to resolve Error code 30145-16

System file checker (SFC) tool is an excellent tool to monitor and check the lost and corrupted system files in the windows. SFC tool will enable the OS to scan and recover the lost/damaged files.

If windows resource security files are lost, then your device and MS Office suite may not run perfectly and it may go failing to run like MS Office software installation, upgrade, update or any other thing may show up errors, or device crashes or restart automatically.

To run SFC tool, 

  • Open the Command prompt and run it as an administrator from the start menu,
  • Write the command SFC /SCANNOW on command prompt and Press Enter
  • This command will scan and check all secured system files on the device and then restore all the damaged files along with a cached copy in the device at %WinDir%\System32\dllcache which describes windows system folder
  • And then see that if Error code 30145-16 is resolved or not

If you are unable to open or operate SFC tool then contact MS Office suite support provider online from office.com/setup.

Solution-2: Temporary block Firewall or Antivirus software to resolve Error Code 30145-16

The Firewall or security software available on the device may sometime recognize and prevent the MS Office installation or update as a role of device security in the background. The MS Office installer is an online setup tool to give the newest characteristics and updates in all the installation.

Here I have given the steps to disable the firewall or antivirus software to resolve Error Code 30145-16

  • To disable Windows Firewall:
  • Go to the Control panel from start menu
  • Search for the firewall and open Windows Firewall
  • In the left navigation panel, Click on the turn-on the Windows Firewall On or OFF button and click on OFF

And then check whether Error code 30145-16 is resolved or not If not any you need someone’s help in it then contact MS Office support team at office.com/setup.

To disable the Antivirus software, you have to follow the steps as per your antivirus software. Each security software has own different settings to disable it. So go to the official website of the antivirus software and follow all the steps.

Solution-3: Edit MS Office Registry keys to Repair Error Code 30145-16

Editing in a Registry key is a dangerous thing because any mistakes in them lead to a big loss so it’s better to call Microsoft support team to get support regarding MS Office at office.com/setup.

Solution-4: Uninstall/Reinstall the MS Office suite

If not any solution helps to you then you can uninstall the MS office suite in your device and then reinstall the program again online from office.com/setup. It will definitely help you.

Get more details at www.office.com/setup

Microsoft Windows 10 April 2018 update almost 50% of PCs installed

As per the third party telemetry data that was released last week talks about the Windows 10 version 1803, also known as April 2018 update, is been recorded to be the fastest spreading  Windows 10 update of all the time.

According to the report from AdDuplex, an advertising company that almost 50% of all Windows 10 PCs that runs the Microsoft’s latest version. On the other hand, AdDuplex an advertising company that collected statistics from almost 5000 Windows Store apps that runs AdDuplex SDK.

Windows 10 April 2018 update

The AdDuplex report is counted to be the best insight about the success of the latest Windows 10 version as Microsoft always remains quiet on Windows 10 statistics.

As per the report, April 2018 update took less than a month to reach 50% mark as compared to Fall Creators Update, 2017 which took almost three months to reach 50% mark.

Microsoft is getting good responses in every passing day and is getting better in every new update including Windows 10 updates.

Moreover, 43% of Windows 10 users aren’t so far away from running the Fall Creators Update and just a click away from the upgraded Windows 10 updates.

Overall it got clear that the huge number of Windows 10 users are running one of the latest two Windows 10 updates and should keep up with the security patches also.

The AdDuplex report is quite astonishing as despite been criticized by the media for the past two month Windows 10 April 2018 still manages to be a success.

The latest Windows 10 update was scheduled to be released in the second week of the month April but the official release got suspended till the last day of the month of April due to the lingering BSOD issues faced.

The media continues to criticized even after the Official release of Windows 10, users have reported several issues regarding that with Intel and Toshiba SSDs (solved now), issues on the systems with Avast installations (fix now) and the other issues of forceful updates to the latest version, which Microsoft is investigating now.

Looking for Office setup support Guide : We have wrote guide on how to setup microsoft office 2013 in 5 simple steps Call Now: 1-888-254-4408

Save

How to enable Macros in Microsoft Office 2007 Compatibility Mode?

Microsoft Office has indeed a huge list of features that makes the way of representation sorted and easy, yet there are still many features, not all the users are aware of all its attributes. A feature named macros is one of the smartest operations explained. Macros give out a series of instructions that are mingled to form a single command. The tool saves time and increases the productivity.

enable-Macros-in-Office-2007

If you open a document created in an older version of Office (containing a macro) in it respective Office 2007 utility, it will launch it in Compatibility Mode. If you carry out further to save the file in compatibility mode, you are leaving the file entirely from its older office format.

This can only be done if you to a few settings to have the access on macros. In order to edit or execute other commands, you need to add the Developer tab to the ribbon in Office setup for its 2007 version.

Macros converted to Office 2007

Prior to the conversion of the files of different format to Microsoft office setup 2007, you need to save a backup copy initially. In case your macro is an older Office version and not available in a utility template, open the file in Office 2007 and choose to save it as a Macro-Enabled Document. Find the following steps to do the required changes.

Add the Developer tab to the ribbon in Office 2007:

  1. To add the Developer tab, click on the start button and search for Microsoft Office 2007
  2. Select any Office utility such as Excel/Word/PowerPoint
  • Make sure it contains Macros
  1. Via Microsoft Office Backstage view, click the file tab and a yellow message bar will appear
  2. Under the same file tab, go to ‘Security Warnings’ area, hit ‘Enable Content’ button
  3. In the section of ‘Enable All Content’, choose ‘always enable this document’s active content ’ so the file becomes trusted document
  4. In the Trust center, go to Macro Settings choose the option as per your need
  5. Click Ok to save the changes

If you are failing to execute the process, check if the Microsoft office setup you have is activated. If not, you may choose to uninstall and then install office setup again. Here, you need to purchase the subscription to get Office product key to license the product.

How to Set the default text style in Microsoft Word?

When you set a default textual style, each new record you open will utilize the textual style settings that you chose and set as the default. The default textual style applies to new archives that depend on the dynamic format, typically Normal.dotm.

Get info Visit at : office.com/setup

You can make diverse layouts to utilize distinctive default text style settings.

Begin with a clear report, or if your archive as of now contains content that is organized with the properties that you need to utilize, select that content.

1. On the Home tab, tap the Font Dialog Box Launcher, and after that tap the Font tab.

2. Select the choices that you need to apply to the default textual style, for example, text style and text dimension. On the off chance that you chose message in stage 1, the properties of the chose content are set in the discourse box.

3. Snap Set As Default, and set the extent of your progressions:

Select This record as it were? on the off chance that you need your progressions to apply to just the present archive.

Select All records in view of Normal .dotm format? on the off chance that you need your progressions to apply to any archive in view of the Normal format.

4. Snap OK to apply your progressions.

How to Change the Default Fonts in PowerPoint?

As opposed to changing the textual style in your slides one by one, you can change the default text style for your whole introduction.

1. Snap View > Slide Master.

2. On the Slide Master tab, tap the Fonts drop-down menu. Select the text style you need to use for every one of the slides in the introduction.

3. Snap Close Master View. The content all through your introduction is consequently refreshed to the new textual style.

How to Create a Template to Save Default Font?

You can spare the above default text style refreshes by making a PowerPoint layout. This format spares your text style refreshes and can be utilized as a part of future introductions.

1. Snap File > Save As.

2. Snap Computer > Browse.

3. Explore to C:\Users\<your username>\Documents\Custom Office Templates.

4. Sort the name of your format in the File Name box. Tap the Save as sort drop-down menu, and snap PowerPoint Template.

Get Office setup Visit at : www.office.com/setup

5. Snap Save.