Tuesday, June 13, 2017

Tutorial Integrating Outlook and Gmail




1)      Open your gmail and click setting


                        2) look at this picture for setting your gmail
                     
3)      And Click Save Changes

4)      Open Outlook and click Next

5)      And then on add email account select option “Yes” and “Next”

6)      After that choose option “Manual set up or additionl server types” nad click “Next”

7)      Choose option POP or IMAP and click “Next”



                        8)Fill form like this picture

                    

9)      After that, click More Settings…

10)   Then, select tab “Advance”

11)  Fill the form like this picture

                        
                   

12)  Click OK
13)  Click Next
And tutorial Integrating outlook and gmail has finish.

Thursday, May 18, 2017

Tutorial Printer Sharing


Two computers are connected

PC A (Bilqis)
1.     Start >> Devices and Printers or Control Panel >> Devices and Printer
 

2.     Right click of Printers properties
 
3.     Choose menu Sharing
4.     Check list on Share this printer and Type Share Name, e.g. Shared Canon iP2700 series
 
5.     Click OK


PC B (LADY)
1.   Open Window Explorer (Window+E) and Click Network
2.   Click name of PC A, (example: Bilqis)
3.   Double click a printer name (example: Canon iP2700 series)
4.   Printer driver is installing
5.   Start - Devices and Printers
6.   Now, we can see an expected printer name

7.   Ready to start printing.





Tutorial Map Directory


1.               We have two connected computers (PC A and PC B), we want to open data from      PC A from PC B
2.               Open windows explorer of PC A


3.               Click Network and Double click name of PC B


4.               Right click a shared folder Click map Network Drive
 


5.               Choose exepected drive name
6.               Click finish
7.               Done and now you have Map Directory
 




Tuesday, April 25, 2017

Tutorial Mailmerge From Excel to Word



TUTORIAL MAKE MAILMERGE 
1. Excell to Word

1.      Make data or table in msc. Excel or Acces, an example of NIM, Name, Department, Address, like the example below: <do not forget to save it first. And then close ms. Excel or Access.
 
2.      After that, open msc. Word, types title on the document same word in Excel or acces like this:

3.      Select mailing menu, select recipients, and then choose "Use an Exsisting File"


Then the menu will appear as shown below. Select the pre-made file, and then select "Open". And the dialog box will appear as below, select OK.





. Select the "insert merge field" menu, adjust it with the title in the column. For example NIM insert merge field with NIM, and so on.



Then it will fill automatically, as in the picture.
 




To display the data, select the "Preview Result" menu, then the data will Look like the following. To move to the next or previous record, click the arrow to the right of the Preview Result.




2. Acces To Word

In this discussion we will discuss how to create mail merge using data from Ms. Access.
As for the steps as follows:
1. Open Ms. Access.
2. create data with file name Lp3i.
3. rename the table with the Student table.
4. input data with No, NIM, Name, Department

 .      After that, open msc. Word, types title on the document same word in Excel or acces like this:

3.      Select mailing menu, select recipients, and then choose "Use an Exsisting File"


Then the menu will appear as shown below. Select the pre-made file, and then select "Open". And the dialog box will appear as below, select OK.





. Select the "insert merge field" menu, adjust it with the title in the column. For example NIM insert merge field with NIM, and so on.



Then it will fill automatically, as in the picture.
 




To display the data, select the "Preview Result" menu, then the data will Look like the following. To move to the next or previous record, click the arrow to the right of the Preview Result.