Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft Office

62K

Solutions

40K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Share tech news, updates, or what's on your mind.

Sign up to Post

If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not to do so.
1
 

Expert Comment

by:Mark Eggink
Comment Utility
Nice article!
1
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
1
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
0
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
4
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA). The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to simplify your life.
1
Blank message list Outlook 2016 for Mac
I came across an unsolved Outlook issue and here is my solution.
0

MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exchange Server is also a reason for its popularity. However, this application is not completely free of issues. Outlook configuration errors, compatibility issues with other email clients, large size, and corruption of its proprietary file format (PST format), etc. are some common issues faced by Outlook users. However, due to the popularity of Outlook, many professional solutions are available to help Outlook users overcome these issues. Here we will discuss some tools that help you to manage MS Outlook efficiently.


  1. Kernel for Outlook PST Repair – For repairing corrupted PST files
  2. Kernel for PST Compress & Compact – For reducing the size of PST files
  3. Kernel for Outlook Duplicates Remover – For removing duplicate emails from Outlook mailbox
  4. Kernel for Attachment Management – For managing PST email attachments
  5. Kernel for PST Split – For splitting large PST files


Kernel for Outlook PST Repair – For repairing corrupted PST files


PST file corruption is a common issue in all versions of MS Outlook. Some of these issues can be fixed using free or inbuilt tools, but not all. That is why even seasoned Outlook users prefer professional PST repairing solutions. One such a tool you can try is Kernel for Outlook PST Repair. It repairs damaged Outlook Data files.  This tool has many features like:


  • Repairs large PST files without any issues
  • Exports emails to Office 365 and emails servers like Exchange server.
  • Recovers deleted emails & attachments (and displays then in RED for preview)
  • Saves emails to different file formats DBX, MBOX, MSG, and EML, etc.
  • Enabled with inbuilt filters which can find required emails instantly.



Kernel for PST Compress & Compact – For reducing the size of PST files


Kernel for PST Compress & Compact is a unique tool which can compact the size of large PST files. This utility helps you to reduce PST size by removing the unused space. This tool has more features which are stated as follows:


  • Compresses & compacts many PST files in single cycle.
  • Integrated with user-friendly Interface.
  • Compresses or removes attachments from emails.
  • Retains integrity while compacting PST files.
  • Removes extra space from PST files.



Kernel for Outlook Duplicates Remover – For removing duplicate emails from Outlook mailbox


Kernel for Outlook Duplicates Remover is a simple tool to remove duplicate items from the Outlook mailbox. It has different options for finding duplicates in Outlook. Following are the features which are included in this tool:


  • Finds and removes duplicate items from PST files.
  • Inbuilt comparison criteria to find duplicate items.
  • Provides various comparison criteria to find duplicate items.
  • Saves list of duplicate items in HTML format.



Kernel for Attachment Management – For managing PST email attachments


Kernel for Attachment Management is an advanced tool to take backups of the attachments and to remove them from Outlook emails. This tool actually saves space because this tool downloads the PST attachments, save them on local machine and then deletes them from Outlook mailbox. Its features are:


  • Restore attachments to any desired location.
  • Compresses email attachments in zip format.
  • Allows to rename attachments with name prefixes.
  • Maintains a log file with the records of attachments processed.
  • Is compatible with all Outlook versions.



Kernel for PST Split – For splitting large PST files


Kernel for PST Split is a tool for splitting large size PST files. This utility efficiently splits large PST files in just few minutes and saves data into smaller PST files. Splitting PST files eliminates chances of PST corruption and improves the performance of Outlook. More advanced features of this tool are listed below:


  • Splits PST files without impacting original data.
  • Splits password protected PST files
  • Provides various criteria like date range to split PST files.
  • You can give desired size to split PST files.
  • Saves different mailbox folders to separate files as per need.



Conclusion


MS Outlook is the most popular email client. Users find this email client easy to use as its interface is very intuitive. Also, users familiar with other Microsoft products find it very convenient too. However, issues are also frequent with this email application. Many of these issues can lead to inaccessibility of emails, calendar, task list, address book, and more. So users always need some utilities that can help them in managing Outlook without issues.

0
Print Preview
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
0
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
0
Take a look at these 6 Outlook Email management tools which can augment the working and performance of Microsoft Outlook to give you a more rewarding emailing experience.
0
 

Expert Comment

by:Alessia Smith
Comment Utility
Informative post...Thanks for share..Once I was also facing Outlook Recovery problem, I use Outlook Recovery Tool which was really very helpful for me..
0
Upgrade your Question Security!
LVL 11
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
0
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
0
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
0
 

Expert Comment

by:Geoff Marsh
Comment Utility
I personally recommend http://www.recoverydeletedfiles.com/word-file-recovery-tool.html which can quickly recover & repair virus attacks, unexpected system shutdown or in case of accidentally deleted Word files. Tool restores word files .doc, .docx, .dot, .dotx and .rtf formats.
0
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
0
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
1
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
1
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
0
New style of hardware planning for Microsoft Exchange server.
1
 
LVL 12

Expert Comment

by:Andrew Leniart
Comment Utility
Hi Abraham, I had to leave for a few days unexpectedly so apologies for the delay in editing.  I should be back in the next few days, however if you would like to have it edited sooner, please use the Request Attention option to contact a moderator who may be able to assist. Other than that, I'll get back on it first thing once I've retuned.

Regards,
Andrew
0
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
5
 
LVL 12

Expert Comment

by:Andrew Leniart
Comment Utility
Thanks for sharing your story. Ransomware is a topic I follow closely and have a lot of interest in. Sorry to hear you were hit by these criminal scum bags and while it irks me to know they profited from your misfortune not once, but twice, I understand the dilemma you were faced with. Backups are something we all tend to fall lax with at times and this story highlights the reasons we all need to stay vigilant. Good luck for the future.
0
 
LVL 1

Expert Comment

by:Josh Petraglia
Comment Utility
Education is Power!

Also, (offline) Backups are your best friend. Just saying.
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
1
 
LVL 4

Author Comment

by:Bob Flisser
Comment Utility
Thanks, Andrew!
0
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
0
 
LVL 50

Expert Comment

by:Martin Liss
Comment Utility
Thanks, that helps and I suggest you mention that the lists are related and also include the description of what you mean by "true database form". And rather than
Each option also then has an identifying code allocation. The codes are calculated in columns H to M...
I'd suggest something like
Each option also has an identifier which is generated via the formulas [that's more familiar to American audiences than formulae] found in columns H to M...
You should also change the reference to "code allocation" in you next to last paragraph.

I find
However, if these three lists are used for DV they would not be dynamic and change based on the selection from the previous category.
a little confusing. Do you mean
However, if these three were used for DV as is, they would not be dynamic because [explain why]

I'm going to publish this no matter what but consider my suggestions and let me know when you're done.
0
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
0


Outlook for dependable use in a very small business

 

This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This is more of a descriptive article than a “how-to” article so there are few screen shots. 

 

As background, I use Outlook because (a) it works and (b) it is a very common email application for computers. I use POP3 and not IMAP because (a) I want my email on my computer and (b) I have outlived many IMAP vendors. I want email on my terms, not someone else’s. I have looked at IMAP but decided against it. Thus far, I have not had reason to regret my decision. 

 

I keep Outlook on two computers so that all received email is on both computers going back to 1996. I keep Sent email on my laptop as I travel around with it. I can always transfer Sent mail to the other computer if I need it. I understand IMAP might solve these issues but I have decided against it for the reasons above.

 

What do I mean by dependability and critical requirements?

 

The same email address “forever”: This is a critical requirement for me. I have had the same email address since 1996. I have no interest in changing it. Since I change ISP companies and they come and go, using an ISP’s email system is not something I can do. If Microsoft had come along in 1996 with Outlook.com, I might have an outlook.com email address but Microsoft was late to the game and I had already decided on a portable email address back then.

 

My end email vendor is a tiny little company in Toronto and I know the players personally. I can call them on the phone when there is an issue. If email is available, they will respond to me very quickly. Most people cannot do this, but I like the capability it offers me. Once in a while they take their customers to dinner and a beer at a local pub. I meet other email customers at the same time. 

 

No spam: Another critical requirement is I do not want spam. And now more than ever, spam is a source of ransomware. I do not want it in my inbox at all. Most users think that they can block ransomware with tools on the computer. Maybe (only Maybe). Blocking spam is the very best way to stop ransomware. 

 

So now there is some complexity. 

 

For email address portability, I use Mail.com. I started using it when it was Four11.com, and when it claimed to be “free forever”. Ha! I continued when it became Iname.com and it was still free. I continue now as Mail.com and pay to use the forwarding service ($30 per year). I forward my email to my current email vendor. My email vendor used to change more often then I changed socks some years back (at least so it seemed to me). Then I found my current email vendor about 20 years ago. They came (more or less) out of Internex.com – one of Toronto’s first consumer Internet vendors. I had the best email address in the world: io.org. It couldn’t last and it didn’t.

 

Let us return to the issue of spam. Mail.com has one of the best email filtering systems there is. It was not always this way, but for the last 10 years they have been top notch. I might see a spam email every other month or even less. I see about 10 emails a month in my spam folder. The rest gets dumped into the bit bucket by spam filtering or grey listing. I am not aware of losing any email that I have not seen, including in the spam folder. 

 

The Mail.com filtering is so effective that regular email from joe@abc.next comes into my inbox, but if Joe’s computer has been compromised or his email address spoofed, the email from joe@abc.next that says “You need to read this www.link.next” goes to spam. Of course, clicking on the link (if it got into your inbox) hoses your computer.

 

My Toronto vendor uses both grey listing and Spam Assassin. Spam Assassin is a good tool and I get essentially no spam from this system. Grey listing is a box or application that looks at incoming email and looks back at the IP address that sent it. If that IP address is not identifiable, the email is not accepted. I have had grey listing running for over 15 years and I am not aware of any lost emails. 

 

Allow me to underscore the point on spam. Eliminating spam is the most important weapon in eliminating ransomware. 

 

Email organization: I get a lot of email and so I keep my Inbox tiny (never more than 50 emails) and I put email into folders as soon I get it or shortly thereafter. I have just over 120 folders. The names are all meaningful so I see no need to use subfolders and there are no subfolders to my Inbox. Email organization is a personal thing and I organize my email to fit myself. Your mileage may vary (YMMV if you come out of the days of DOS).

 

Email archiving: Rule 1 – Archive your email. It works and it is silly not to use the Archive function. Take a look in here (Experts Exchange) – Email is slow, sluggish, broken (take your pick). How big is your email file? I ask. 40 GB. Duh!

 

Open Outlook, File, Options, Advanced, Auto Archive Settings. See below:

 

 

I auto archive every 30 days, archive everything older than 10 months, and never delete old items. At somewhat irregular intervals, I archive into a new file. I have 6 archive PST files plus my current email PST file, all of which are below 2 GB. 

 

One trick / defect of Outlook is that the folder archive option is normally not on by default. I think that is because most people keep email in their Inbox. I do not. So, two things:

 

1. Go to the Properties of each folder and make sure the Archive Option is ON


2. Go back to the main Archive options and select Archive Now. 

                            

Contacts: I keep my Contacts in the Contact folder by individual. It is a big mistake to assume Auto Complete will never go wrong. It will go wrong, precisely at the wrong time for you. Use Contacts. I do not archive contacts. 

 

Calendar: I live from my calendar. I make appointments for everything I do, keep a brief description of what must done in the appointment line, and keep notes and expenses in the note area of the calendar item. I do archive calendar items. 

 

I have done this for years, before Blackberries and iPhones. When I got my first smart phone (a Blackberry) I began to sync Contacts and Calendars (all items in the current PST file but not archives) and now have this readily available on my smart phone. 

 

Sync to Smart Phone: My current phone is an iPhone SE (6s) and I use iTunes to sync the items. It means my iPhone tells me where I am supposed to be and what I am supposed to do. This is outstanding organization when I am busy and nothing can be left to chance. Syncing to iTunes also backs it up, so if my phone is damaged (happened once) a new phone can be set up in minutes. 

 

 

 

Outlook Main Screen Organization:  I keep a traditional organization screen – folder tree on the left, Inbox top middle, Preview bottom middle and calendar on the right. I know where things are, what my current email is and where I am supposed to be. 

 

 

Keeping email on two computers using POP3:  There are several ways to do this. I use POP Peeper (esumsoft.com) as an email daemon to see if there is email, action Experts Exchange email without downloading it and deleting trivial email I do not need to keep. I set Outlook on both computers to never delete email. When I have it on both computers, I delete with POP Peeper. 

 

I never send email from my desktop computer, only from my Laptop. So, my laptop has all email – received and sent email. My desktop has all the received email. Accordingly, I need only back up my main PST on my laptop about monthly or when I am going away for a week or so.

 

Doing all the above takes a bit of incremental time, but practice (more than 15 years of it) makes it easy and provides me with a powerful organizational tool that is fast and efficient (because I archive) and tells me what I need to be doing (Calendar). I can easily get a Contact on the phone because I sync via iTunes (Contacts). 

 

I trust the above will help you use Outlook more effectively.

 


5
 
LVL 52

Expert Comment

by:Jackie Man
Comment Utility
Interesting.

Your writing and presentation s are much better than mine.

I use POP for archiving whereas IMAP for instance response so that you can see all sent emails at all mobile devices and removing all SPAM before I got the same email vis POP after a day or a week of work.
0
 
LVL 100

Author Comment

by:John Hurst
Comment Utility
Thank you for you kind and gracious comments. You brighten my day!
0
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
2
 
LVL 29

Expert Comment

by:Shums
Comment Utility
Great Expert with great mind
0
 
LVL 50

Author Comment

by:Martin Liss
Comment Utility
Thanks.
0
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
2

Microsoft Office

62K

Solutions

40K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.