Quick Bytes IT Stuff

Outlook is a very good tool, however if it gives some issues, it can ruin your day or your mood to work. Well, as the odds say nothing is perfect and even the flowers on the field that looks so beautiful will one day fade away. Same goes with our electronic devices, you just don’t know when it will go south. It might even give you issues when you needed it most to work properly, and sometimes that will be the time that it will not work as expected. Anyway, problems will always be there. The only question is, how will you face the issue or problem? For Outlook not responding and also the network or WiFi keeps disconnecting even though your phone or other devices or laptop has no issue to the network. It seems that the laptop has been singled out, and that’s the only device on the network that is not working. There are various approaches to solve this issue. Sometimes, it’s the same issue Outlook not responding or no network, but then different ways to resolve the problem. Yes,...

How to search for a string in the body of Outlook emails? How to search for a string in Outlook emails using VBA? How to find a string in Outlook email body using VBA? Outlook VBA code below searches a string on the email body and move the email to a specified folder. Replace variables below with the actual folders and string to search in Outlook: Destination_Folder_01 Folder_to_be_Searched string to be searched Folder_to_be_Searched - all emails in this folder will be searched and if the string matches the will be moved automatically to the destination folder.  string to be searched - this string will match on the body of the emails Sub MailItemContent_Move_Search() Dim olItem As Outlook.MailItem Dim sText As String Dim myNameSpace As Outlook.NameSpace Dim myInbox As Outlook.MAPIFolder Dim myDestFolder2 As Outlook.MAPIFolder Dim mySearchFolder As Outlook.MAPIFolder Set myNameSpace = Application.GetNamespace("MAPI") Set myInbox = my...

Have you received an email saying please find the picture below, but the picture is on the attachment not on the body of email. Or sending out a nice an beautiful layout of graphics hoping to impress a colleague or client only to find out that the the graphics doesn't display correctly in Outlook or either in the mobile phone. HTML Tables has been a big help for web designers or developers before the CSS era or other good platforms at this time. Well, if picture is not displaying properly in Outlook or mobile phone. Embedding or inserting the picture in a Table, seems to be a good quick solution in inserting pictures via Outlook and it will display properly in mobile phone also. When composing email in Outlook, click on the Insert option and click on insert table. If sending two pictures, you can insert a two rows or two columns and insert the picture on each row or column. After sending out the email, check the email in Outlook or mobile phone and if everything goes ok...

How to get Outlook address book names via VBA? Outlook has the option to create multiple address books. Of course, it's for a good reason, to organize address books. Well, why need to organize? I guess the reason will depend on every individual whether it's a thing to practice or a thing to be ignored. Outlook address book can be set to manage contacts. For example, you can have an address book just for Personal use which includes friends and family. You can set the address book for vendors and another address book for customers only and of course contacts within the organization. Organizing is a skill if not an attitude to make work easier and manageable. VBA code below will get all the address book names on Outlook, and once the address book is known you can expand the code to get contacts for each specific address book by supplying the address book name. ====================================== Sub getfoldercontact_addressbook_names...

VBA code below will get and set paper tray settings of a word document. Macro tested on Word 2010. Values 7 and 1 are the value output from the message box. I'm not sure whether values are dependent on printer driver. On my word 2010 those are the values that can be used to set paper tray settings. 7 - will set to "Automatically Select" 1 - will set to Tray1 If got documents received from other party that always retain the printer settings. A macro will be useful to change the settings or by doing it manually by going to Page Setup and change the paper tray settings. Sub getpapertray() Dim xtray1, xtray2 xtray1 = ActiveDocument.PageSetup.FirstPageTray xtray2 = ActiveDocument.PageSetup.OtherPagesTray MsgBox xtray1 MsgBox xtray2 'Set the tray to Automatically Select ActiveDocument.PageSetup.FirstPageTray = 7 'Set the tray to Tray 1 ActiveDocument.PageSetup.OtherPa...

Sub Macro_VBA_Delete_Page() Selection.GoTo wdGoToPage, wdGoToAbsolute, 2 Selection.Bookmarks("\Page").Select Selection.Delete Unit:=wdCharacter, Count:=1 End Sub Selection.GoTo wdGoToPage, wdGoToAbsolute, 2 Line above will goto page number "2" Selection.Bookmarks("\Page").Select This will select the whole page. Selection.Delete Unit:=wdCharacter, Count:=1 As the keyword specified "Delete", it will delete the whole page   To delete 2 subsequent pages using VBA use code below: Sub Del_pages() Dim i  For i = 1 To 2 Selection.GoTo wdGoToPage, wdGoToAbsolute, 2 Selection.Bookmarks("\Page").Select   Selection.Delete Unit:=wdCharacter, Count:=1  Next End Sub Code above will delete page 2 and page 3 on the word document Selection.GoTo wdGoToPage, wdGoToAbsolute, 2 Code above will goto page 2 and once page 2 is deleted, page 3...

To delete a selected page anywhere in a word document, is quite easy and straight forward. Follow steps below: 1. Press Ctrl+G on the keyboard 2. Find and Replace window will open. (see image) 3. The default tab will be “Go To tab".    Type "\page" (don't include the quotes), on "Enter page number" box. 4. Click "Go To" button, it will select the whole page. 5. Click the "Close" button. Find and replace window will close. 6. Finally, press "Delete" key on the keyboard to delete the selected page. 7. Press Ctrl+Z, if you change your mind it will bring back the deleted page. Tested in Word 2010. Cheers!! Hope it helps.. ========================= Heaven's Dew Fall https://play.google.com/store/apps/details?id=soulrefresh.beautiful.prayer Android Catholic Rosary App - Guide https://play.google.com/store/apps/details?id=com.myrosaryapp&hl=en-GB Educationa...