Wednesday, May 28, 2014

how to extract images from .docx/.doc Word documents

Lately I've been in a situation where I had an image embedded into a .docx Word document, and I absolutely needed to get the original image file in order to be able to retrieve the original best-quality picture. See the screenshot below? My document contains a picture, it shows up as a small thumbnail, but I need the original high-resolution picture. This tutorial shows the way, it works with Microsoft Word 2007 and above.

There are several ways to retrieve or extract images from a Word document. I am going to be listing the top 3 ways to do so in this article. Feel free to use whichever way you want, but expect different results. Here is the article index here:
  1. Renaming the .docx to .zip, opening the zip file and extracting the images (Best way!)
  2. Copying and pasting the image into a picture processing application (Alright)
  3. Saving the document as a web page and retreiving the generated images (Nice!)
Alternatively you could just use the Snipping Tool from Windows Vista/7, which allows you to save a portion of the screen into an image. Try it, it's pretty much self explanatory, but the final quality of the picture depends on how much you can fit on your screen.

Option #1: renaming the .docx to .zip

This is definitely the best way to retrieve your images. Microsoft Word's .docx documents are actually zip files! Before you ask: what if your document is a .doc, a .html, .odt or any other format? Well just open the document in Word and save it as .docx file, Word will convert it to a zip/docx file for you. So here is my file:

Note: if you do not see the .docx at the end of the file name, you *MUST* follow this tutorial for this to work (this will help you show file extensions in Windows Explorer).

I am going to rename the file to "products.zip" here, note as seen on the screenshot below, the icon changes to something different:


Now, double click your .zip file to open it with whatever program is associated with Zip files on your computer. In my case, Winrar does the job. If the document still opened with Word, you probably did not read carefully enough -- go back to the part where I say to follow this tutorial.

Open the "word" folder as seen in the above screenshot. You should be seeing a "media" folder:

Open it, and you'll now see all the images that appear in your document.

These are the original images that were inserted in the documents, regardless of the size in which they appear when viewing your document. You can extract them to your storage disk by selecting them and dragging&dropping them to the folder of your choice.

Option #2: copying and pasting the image

Another obvious option is to simply select the picture in Word, click Ctrl+C to copy the picture to the clipboard:

If you have and use a design/picture processing tool such as Photoshop, Paint shop pro or something, just open it and paste the picture by pressing Ctrl+V. I don't have anything like this, so I'll just open Paint:

Press Ctrl+V to paste the image into the current canvas in Paint. Unfortunately, the picture is copied in the same size as it appears in Word. If you want a bigger version, you'll have to resize the image in Word first, copy it again, and paste it again in Paint! This is obviously not the best way to go, but it can be easier and faster than the first option I described earlier.

Option #3: saving the document as a Web page

This last option is technically the easiest in my opinion. First, open your document in Word, then save it as a Web page:

When offered to select the format, make sure to choose the "Web page" format... do NOT select "Web page (filtered)", this option will export low-resolution images. The "Web page" option on the other hand exports the original images as well as thumbnails.

Once the file is saved as a Web page, you will find that two new icons appear in your folder:
There's the document itself, but also a folder that Word generated for you. Open the folder to reveal the images (both in original and thumbnail sizes):

You can now copy or save those files to other folders of your computer.

Conclusion

That's it! That wasn't so hard, was it? I still wonder why Microsoft didn't originally include this feature in the Word application itself. In my opinion, we should be able to just right-click an image and see a "Save image as..." option in the menu.

Now, why did I bother writing about this on what is seemingly a sysadmin's/developer's blog, you ask? Because I've been looking this up on the web and most of the answers I found were unsatisfying. It took me ages before I finally stumbled upon a blog article that revealed the docx/zip trick. When I don't (or hardly) find the answer to my questions, I usually whip up a quick article about what I was looking for, and hopefully it ends up helping people.

Sunday, May 25, 2014

How to Send any files instantly from one device to another with Send Anywhere

Looking for a simple yet effective way to send any file instantly from one device to another? check out Send Anywhere. It’s a unique web service that gives you the ability to transfer files over 3G/4G or your WiFi connection.

It supports any type of files, how large they are and there’s also no limit on the number of files you’re sending. Another thing that caught my attention with Send Anywhere is that the files we’re sending aren’t stored anywhere on the internet, their priority transferring path is p2p, with NO going through server unless the connection isn’t good. That’s when it’ll pass through an optimal node server, still, without storing.
Here’s how it works.
There is no sign-up or log-in required, no need to register for anything. Visit the website and simply add files that you want to send.


After you’ve selected the files, click on ‘send files’. You’ll instantly receive a random/unique key. If there are devices nearby, click on ‘send key’ and it will start searching. Go to the receiving device or simply give the key to the recipient whom you want to send the file.

As soon they input the key and click on receive, you’ll see a notification that the file has been transferred. And that’s it. It’s as simple as that.
Features like sending files directly & instantly across networks (local network or via cellular data) and across all platforms & connected devices (Android, IOS, Web) is something you’ll really like. More features are coming soon as well.
Check out Send Anywhere

How To Remove Installed Applications From Windows 8

When you freshly install an operating system, there will be some of the basic applications available by default. Especially in Windows, all the basic stuffs like Notepad, Wordpad, Paint, etc., will be installed automatically. Windows 8 has moved a step forward and comes with plenty of Microsoft applications by default. This might be helpful at sometimes, but many users find these apps are unwanted in their PC. The problem in Windows is, it doesn’t have an option to uninstall the default apps, but we have many third party applications available to do that. Today, I’ve come with one such application called “Windows 8 App Remover”, exclusively for Windows 8 users. Here’s how it  works.
Windows 8 App Remover is a free application for PC, which also works with the new Windows 8.1 update. You can download the app using the link at the end of this post. After you install the app, you will see a screen as shown in the screenshot below. In Windows 8, there will be default apps like Bing Sports, Weather, Zune Music, Video, etc. All the junk apps on your PC will be listed on the home page of the application. You can select them all or choose the one you need and remove all the apps at the same time.



To start removing the apps, first you have to choose the versions of Windows in the top left corner. The apps available on your PC will be highlighted and other apps will look gray. The app also has an option to uninstall apps by mounting .wim (Windows Imaging Format) files from your PC. All the apps you uninstall using app remover cannot be restored. If you want the app again, you have to download and install that particular application manually.
This is a must have application for all the Windows 8 users to free up some space and it gives a clutter free interface. Try this new app on your Windows machine and share your experience with us in the comments. Thanks for reading, do share this post with your friends.

Saturday, April 19, 2014

How to Import Yahoo Mail Contact in Outlook

There are numerous web-based email services to choose from, and as new ones pop up or start to gain new features it is quite common to find that you want to move from one to another. If you have been lured by Outlook.com but have been reluctant to leave behind your Yahoo account, for instance, Microsoft just made things a whole lot easier. It’s now possible to import your Yahoo account into Outlook.com so you can keep all of your old messages while taking advantage of Microsoft’s advanced email service.
Making the import is pretty simple. Start by logging into your Outlook.com account, click the gear icon to the upper right hand side of the page and select Options from the menu. In the Manage your account section, click the Import email accounts link.
You’ll see that there is an entry labelled Yahoo, and if you click this you will be prompted to enter your Yahoo username and password. Enter your login details and click Import.
import_yahoo_1
You will have to wait for a few minutes while all of your emails are imported, but you can continue to use Outlook.com for other things in the meantime.
Once the import is complete, you’ll not only have access to all of your old emails, but you will also be able to continue to send emails via that old address through Outlook.com — a great help in making the transition.

How to Activate Airtel Voicemail service for free on your Prepaid Mobile

Airtel provides Free Voicemail service for all prepaid customers but unfortunately no one is aware of it. Even Airtel website or customer care representative is unaware of it.
Activation by Call Code:
  • Call *321*671# for Activation
  • Call *321*673# for Deactivation
Activation by SMS Code:
  • START VMS to 54321 for Activation
  • STOP VMS to 54321 for Deactivation
Voicemail Account Management:
To access your Voicemail Account Management, call Dial 52555 from your registered Airtel Prepaid Mobile. For the very first time, it will prompt you to set a 4 digit passord. Next time you need to enter the password to access your profile settings.
With your account Management, you can do the following things
  1. Change your language presence
  2. Set your Own Custom Voicemail Message
  3. Hear, Save and Delete the received voice mail messages
  4. Change Voice mail box name
You can press the following numbers to perform action on your current running Voicemails
  • Delete – 3
  • Reply – 4
  • Save – 5
  • Previous Voicemail – 6
  • Replay Again – 7
  • Next Voicemail – 8
  • Settings – 9
Settings Page:
  • When you login to setting, Press 2 to change language presence
  • Rename Mailbox Name – 3
  • Change Password – 4
  • Hear or Change current welcome message – 7
  • Remove current Welcome Message – 8

Saturday, April 12, 2014

HOW TO SHOW BLANK CELL RED EXCEL CONDITIONAL FORMATTING






1. Select cells you want to format
2. On Home Ribbon go to Conditional Formatting --> Highlight Cells Rules --> More Rules...
3. In "New Formatting Rule" pop-up select "Format only cells that contain" option from "Select a Rule Type:" section
4. In same pop-up window select "Blanks" options from drop-down-list given under "Edit the Rule Description:" section
5. Again, in same pop-up window click "Format.." button to define type of formatting you wish and click "Ok" to close window