Thursday, December 24, 2015
mail merge from excel to word
create certificate for a group of people using mail merge
>>>>>>>>>>>>>>>>>>>>>>>>>>>
First create the certificate for one person or use already created one in MS Word.
Select Mailings tab. Then click start mail merge. A list pops up and slect step by step mail merge wizard.
In the mail merge wizard, go on with letter, then select radio button starting document as 'use the current document'. then comes step 3 that states 'select recipients' and there are several option. To use Excel file select 'use an existing list' and click 'browse' that is shown under the heading of use an existing list.When you click browse, you need to select the required excel file. Then it comes 'Select table'. you may select the 'sheet 1' and check mark that 'first row of data contains column headers'. Next the whole excel file's data on that sheet appears which may be sorted if required. However, in generally you should click ok and from step 3, go to step four by clicking 'Next: write your letter'.
When it comes to step 4'write your letter', better select more items and pick name with database radion button on. Then click insert. By the by, before clicking insert, you should put your cursor on the place of the document where you want to put 'name'. There you may select font and font size. Then it would appear as <> inside less than greater than close bracket.By the by, you may change font and size later by selecting the <> and putting appropriate font and size.
Then go to step 5'preview your letters'. Next go to complete the merge which is the step 6 of 6. Here it is always suggested to click Edit individual letters to find out how each certificate would appear for each person. Then you may save this file for later use. By the by, the file where you started would be saved as well with the codec you have use.
The very useful guide with screenshot:
http://www.timeatlas.com/mail-merge-word-excel/
>>>>>>>>>>>>>>>>>>>>>>>>>>>
First create the certificate for one person or use already created one in MS Word.
Select Mailings tab. Then click start mail merge. A list pops up and slect step by step mail merge wizard.
In the mail merge wizard, go on with letter, then select radio button starting document as 'use the current document'. then comes step 3 that states 'select recipients' and there are several option. To use Excel file select 'use an existing list' and click 'browse' that is shown under the heading of use an existing list.When you click browse, you need to select the required excel file. Then it comes 'Select table'. you may select the 'sheet 1' and check mark that 'first row of data contains column headers'. Next the whole excel file's data on that sheet appears which may be sorted if required. However, in generally you should click ok and from step 3, go to step four by clicking 'Next: write your letter'.
When it comes to step 4'write your letter', better select more items and pick name with database radion button on. Then click insert. By the by, before clicking insert, you should put your cursor on the place of the document where you want to put 'name'. There you may select font and font size. Then it would appear as <
Then go to step 5'preview your letters'. Next go to complete the merge which is the step 6 of 6. Here it is always suggested to click Edit individual letters to find out how each certificate would appear for each person. Then you may save this file for later use. By the by, the file where you started would be saved as well with the codec you have use.
The very useful guide with screenshot:
http://www.timeatlas.com/mail-merge-word-excel/
Labels: computer
Wednesday, October 28, 2015
split,merge,compress pdf files -- all these could be done online for free!
http://smallpdf.com/
nice organized site.
In the compressed file no watermark is provided and everything is done online. And the best part is that its totally free.
nice organized site.
In the compressed file no watermark is provided and everything is done online. And the best part is that its totally free.
Labels: computer, online, pdf, software
Friday, October 23, 2015
Folder Icons
Download the icons as icon or icns. For XP,better be older one that is icon. If you save as png file, it may not come up.
some nice collections at
http://www.iconarchive.com/show/windows-business-icons-by-rskys/My-Documents-icon.html
drawing like kids icon gallery
http://www.iconarchive.com/show/harmonia-pastelis-icons-by-raindropmemory.html
aurora icons
http://www.iconarchive.com/show/aurora-folders-icons-by-icontexto.html
legend type icon
http://www.iconarchive.com/show/legendora-icons-by-raindropmemory.html
All country icon
http://www.iconarchive.com/show/all-country-flag-icons-by-custom-icon-design.html
some nice collections at
http://www.iconarchive.com/show/windows-business-icons-by-rskys/My-Documents-icon.html
drawing like kids icon gallery
http://www.iconarchive.com/show/harmonia-pastelis-icons-by-raindropmemory.html
aurora icons
http://www.iconarchive.com/show/aurora-folders-icons-by-icontexto.html
legend type icon
http://www.iconarchive.com/show/legendora-icons-by-raindropmemory.html
All country icon
http://www.iconarchive.com/show/all-country-flag-icons-by-custom-icon-design.html
Labels: computer, folder icons
Tuesday, September 22, 2015
solution:when Computer turns off suddenly and without warning
Good suggestion at:
http://www.computerhope.com/issues/ch000689.htm
most probably it is CPU heating related issue.
Another good suggestion at:
http://superuser.com/questions/190620/why-does-my-computer-power-off-suddenly-and-without-warning
In my computer, I could turn on after it turned off without warning using UPS, not direct line electricity. It is weird but it works. Again, on opening up the computer, the screen shows CPU temperature and when it goes around 37 or higher Celsius that may mean it is too heat and may turn off soon.
Labels: computer
Saturday, August 01, 2015
Convert pdf to jpg image and Post Your PDF On Facebook
3 Different Ways To Post Your PDF On Facebook
http://www.investintech.com/resources/blog/archives/2841-3-different-ways-to-post-your-pdf-on-facebook.html
I think converting pdf to image and upload those as photo is the best option.
The simple way is to use online converter that do multiple pagers of one pdf file to separate images in one go.
http://www.wikihow.com/Convert-PDF-to-JPEG
Find an online PDF to JPG converter. There are several to choose from, and most are free to use. These services allow you to upload your PDF file which will be converted to JPG format. If you have multiple pages in your PDF document, each page will be converted to a separate JPG file.
Click the “Choose file” button on the online converter of your choice. Browse your computer for the PDF file that you want to upload. One of the limits to these services is that file sizes are typically limited to 25 MB per file (100 MB in Zamzar’s case and no limit on Smallpdf).
Online converters typically set their default quality at 150 DPI, which results in decent quality conversions. You can usually change this to 300 DPI, which will dramatically improve the quality but lead to a much larger file.
Sometimes you will need to select JPG as the desired output format (others have JPG selected as standard).
Many services will optionally email you once the conversion process is complete, or will email you the download links for the converted file.
If your file has multiple pages, you may be given links to download each page individually, or you can download all of the files at once in ZIP archive format.
http://smallpdf.com/pdf-to-jpg
nice little one
its privacy policy states "Your PDF and JPG files will be deleted from our servers an hour after the conversion. No-one has access to those files and your privacy is guaranteed."
http://pdf2jpg.net/
it has quality options and it also states that no watermark would be given in the pages. Further all documents uploaded will be deleted.
http://www.investintech.com/resources/blog/archives/2841-3-different-ways-to-post-your-pdf-on-facebook.html
I think converting pdf to image and upload those as photo is the best option.
The simple way is to use online converter that do multiple pagers of one pdf file to separate images in one go.
http://www.wikihow.com/Convert-PDF-to-JPEG
Find an online PDF to JPG converter. There are several to choose from, and most are free to use. These services allow you to upload your PDF file which will be converted to JPG format. If you have multiple pages in your PDF document, each page will be converted to a separate JPG file.
Click the “Choose file” button on the online converter of your choice. Browse your computer for the PDF file that you want to upload. One of the limits to these services is that file sizes are typically limited to 25 MB per file (100 MB in Zamzar’s case and no limit on Smallpdf).
Online converters typically set their default quality at 150 DPI, which results in decent quality conversions. You can usually change this to 300 DPI, which will dramatically improve the quality but lead to a much larger file.
Sometimes you will need to select JPG as the desired output format (others have JPG selected as standard).
Many services will optionally email you once the conversion process is complete, or will email you the download links for the converted file.
If your file has multiple pages, you may be given links to download each page individually, or you can download all of the files at once in ZIP archive format.
http://smallpdf.com/pdf-to-jpg
nice little one
its privacy policy states "Your PDF and JPG files will be deleted from our servers an hour after the conversion. No-one has access to those files and your privacy is guaranteed."
http://pdf2jpg.net/
it has quality options and it also states that no watermark would be given in the pages. Further all documents uploaded will be deleted.
Tuesday, July 28, 2015
Apps dowload to pc or laptop as .apk file,later transfer to mobile
Lately I could not use google play store installed in my Goldberg Zap FX1 mobile. When I logged in, it asks to redeem though I did not get any redeem code to my email. So I could not browse playstore for apps or install. Same applies to gmail, I could not access the gmail. Well there may be some malware or virus in the mobile. I just bought it, so it might have infected while Android kitkat and other built in apps were installed.
Then I tried to download through the following method. But it did not work as in mobile it showed error in downloading.
http://www.howtogeek.com/161366/5-ways-to-install-android-apps-on-your-phone-or-tablet/
It provides all the info
Use the same gmail account you are using for your mobile to download apps through pc. As you click install it may ask to which phone it should install.
So I have gone for the following download apk file using evozi.com link generator
>>>>>
Alternatively, allow download from unknown source, then download the APK file to your computer, transfer to your mobile using usb,then install it. It is called sideloading.
If your Android device is short on space, or you want to work around country restrictions, then you can simply download an APK file directly from Google Play to your computer and install it on your device later. Effectively, you can store an APK collection on your hard drive or cloud storage, then dip into it when you want to grab an app. Here's how to download APKs to your PC.
https://www.androidpit.com/how-to-download-apk-file-from-google-play
Download APK file from Google Play using a website
If you're a more casual APK downloader then a Chrome extension is probably not really necessary. Instead, you can just visit a dedicated site for generating APK download links whenever you need to.
Go to the Play Store and find the app you want to download.
Copy the app's URL address from the browser's address bar.
Next, go to a site like Evozi's APK Downloader (Evozi also has a Chrome/Firefox extension)
http://apps.evozi.com/apk-downloader/
and paste the app package name (or the whole Google Play URL if you're lazy) in the box at the top of the page.
Hit the blue button to generate the download link and save it to your computer.
Sideload the APK to your phone/tablet and install it as above.Here you need to check to allow unkonwn source in security features in your setting.
nstall APK file on your Android device
Enable 'Unknown sources' in your phone's security settings (Settings > Security > Unknown sources) to transfer APKs from your PC.
Connect your phone to your PC using a USB cable. The necessary drivers should install automatically and your phone should show up like a USB storage device.
Next, copy the APK you downloaded to your PC onto your phone (this is called ''sideloading''). I'd recommend an obvious location like the Downloads folder.
Go to the Downloads folder on your phone using its File Manager app, then tap the APK you just transferred over. It will request your permissions then install itself to your device.
For your peace of mind and security, disable ''Unknown Sources'' when you’re done.
Then I tried to download through the following method. But it did not work as in mobile it showed error in downloading.
http://www.howtogeek.com/161366/5-ways-to-install-android-apps-on-your-phone-or-tablet/
It provides all the info
Use the same gmail account you are using for your mobile to download apps through pc. As you click install it may ask to which phone it should install.
So I have gone for the following download apk file using evozi.com link generator
>>>>>
Alternatively, allow download from unknown source, then download the APK file to your computer, transfer to your mobile using usb,then install it. It is called sideloading.
If your Android device is short on space, or you want to work around country restrictions, then you can simply download an APK file directly from Google Play to your computer and install it on your device later. Effectively, you can store an APK collection on your hard drive or cloud storage, then dip into it when you want to grab an app. Here's how to download APKs to your PC.
https://www.androidpit.com/how-to-download-apk-file-from-google-play
Download APK file from Google Play using a website
If you're a more casual APK downloader then a Chrome extension is probably not really necessary. Instead, you can just visit a dedicated site for generating APK download links whenever you need to.
Go to the Play Store and find the app you want to download.
Copy the app's URL address from the browser's address bar.
Next, go to a site like Evozi's APK Downloader (Evozi also has a Chrome/Firefox extension)
http://apps.evozi.com/apk-downloader/
and paste the app package name (or the whole Google Play URL if you're lazy) in the box at the top of the page.
Hit the blue button to generate the download link and save it to your computer.
Sideload the APK to your phone/tablet and install it as above.Here you need to check to allow unkonwn source in security features in your setting.
nstall APK file on your Android device
Enable 'Unknown sources' in your phone's security settings (Settings > Security > Unknown sources) to transfer APKs from your PC.
Connect your phone to your PC using a USB cable. The necessary drivers should install automatically and your phone should show up like a USB storage device.
Next, copy the APK you downloaded to your PC onto your phone (this is called ''sideloading''). I'd recommend an obvious location like the Downloads folder.
Go to the Downloads folder on your phone using its File Manager app, then tap the APK you just transferred over. It will request your permissions then install itself to your device.
For your peace of mind and security, disable ''Unknown Sources'' when you’re done.
Friday, June 05, 2015
Laptop Battery, got it cheap in Modina Computer,Uttara,Dhaka
Finally got the laptop battery on 5 June 2015. Price is very reasonable as Ryans computer says the price may be around 1800 and in the online shops are selling it at 1800.
When I went to HM plaza to find out the battery, all usual computer shops said they did not have it and referred to Modina Computers.
Modina computer is located on the third floor(bangla char tala). There is a stair on the road leads to Hungry duck. To park car, that side is suitable.
Mr. Mahfuz, young and religious person beard, dealt with my request as I went there on 31 May 2015. On that day they did not have my laptop battery. Mr Mahfuz rang to some other guy and informed it would be arrived next day. Well, as usual the battery did not arrive next day and I got it after five days on Friday. By this time, I rang everyday to find out the status. Anyway, they charged the lowest possible and it is amazing. Since in UTtara price of everything is little higher due to transport cost from Dhaka city centre.
Her goes the contact details:
Modina Computer
Shop no 25, 3rd floor, H.M. Plaza, Road 2, Sector 3, Uttara, Dhaka 1230,Bangladesh
Tel: +880-2-8931824
Mob:01190527333 ;01610 527333
Website: http://www.modinacomputers.com/
Modina computer is spealized in laptop repair and I highly recommend it As I browsed through their website, I found that only address is given and interestingly there is an internet based online tracking of work or order is provided. Just one need to enter his token no of work and status with payment details could be available. it is simple but I think a great way to inform customers about work in progress.
For checking price, Ryans computers Dhaka publishes monthly price update:
http://www.ryanscomputers.com/Productbook
Lately there is an online computer laptop accessories shop that do cash on delivery:
http://rnasso.com/product-list.php?cat=Laptop+Battery&brand=ASUS
When I went to HM plaza to find out the battery, all usual computer shops said they did not have it and referred to Modina Computers.
Modina computer is located on the third floor(bangla char tala). There is a stair on the road leads to Hungry duck. To park car, that side is suitable.
Mr. Mahfuz, young and religious person beard, dealt with my request as I went there on 31 May 2015. On that day they did not have my laptop battery. Mr Mahfuz rang to some other guy and informed it would be arrived next day. Well, as usual the battery did not arrive next day and I got it after five days on Friday. By this time, I rang everyday to find out the status. Anyway, they charged the lowest possible and it is amazing. Since in UTtara price of everything is little higher due to transport cost from Dhaka city centre.
Her goes the contact details:
Modina Computer
Shop no 25, 3rd floor, H.M. Plaza, Road 2, Sector 3, Uttara, Dhaka 1230,Bangladesh
Tel: +880-2-8931824
Mob:01190527333 ;01610 527333
Website: http://www.modinacomputers.com/
Modina computer is spealized in laptop repair and I highly recommend it As I browsed through their website, I found that only address is given and interestingly there is an internet based online tracking of work or order is provided. Just one need to enter his token no of work and status with payment details could be available. it is simple but I think a great way to inform customers about work in progress.
For checking price, Ryans computers Dhaka publishes monthly price update:
http://www.ryanscomputers.com/Productbook
Lately there is an online computer laptop accessories shop that do cash on delivery:
http://rnasso.com/product-list.php?cat=Laptop+Battery&brand=ASUS
Saturday, January 03, 2015
Copy folders without content
Freeware Treecopy is
small utility that could do this task with graphical interface.
As the Treecopy briefly states - Have you ever needed to
copy a directory structure without copying the files? TreeCopy now makes this
possible. Our small program will allow you to select the "from
directory" and "into directory", and it will proceed to copy
ONLY the directory structure(only folders with names are copied, no contents
are copied). The utility is bundled with functionality such as a command line
interface, calculate directories, Windows XP look and feel and much, much more!
If you would like to use command line cmd or other options, you may look up the following website:
Labels: computer