Office 365

5K

Solutions

91

Articles & Videos

3K

Contributors

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

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

Sign up to Post

Microsoft Bookings Review
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
2
 

Expert Comment

by:Daniella Barion
I totally agree with you, time zone match and customers information with easy access are big things.
1
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

How to change email signature in Outlook on the Web (OWA)
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA).

For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651

If you want to manage email signatures and disclaimers for a whole company, visit https://www.codetwo.com/email-signatures/?sts=6651
0
How to setup an Office 365 email signature
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365 users. When this email signature has been created, it will automatically be applied to all outgoing messages via an Office 365 Transport Rule.

Follow the step-by-step instructions below or watch our comprehensive video guide on how to create an Office 365 email signature using a Transport Rule.
0
How to backup Office 365 mailboxes locally
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365.

Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/
0
The Email Laundry
A company’s greatest vulnerability is their email.

CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to reach $2 trillion by 2019.

When a company’s email is down, business is down.

To prevent your company from cyber crime, email security is the only solution.


The Email Laundry keeps you safe from the threats organisations face every day with cutting edge CEO Algorithms, Phishing Sensors, URL Scanners and Threat Intelligence.

The Email Laundry’s comprehensive service barricades your organisation from all incoming threats which allows you to focus comfortably on your company's interests.

The Email Laundry are trusted worldwide by secured multinational companies in the healthcare financial, oil and gas industries.

We are also the highest rated email security company by IT professionals on Spiceworks.

The Email Laundry guarantees to keep your company safe!
0
Polish Reports in Access
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled out.

If you haven't already seen it, watch and do all the steps for 'Create a Query and Grouped Report and Modify Design using Access'
https://www.experts-exchange.com/videos/4514/Create-a-Query-and-Grouped-Report-and-Modify-Design-using-Access.htm

1. Download the START and SOLUTION databases

ReportPolish_START_SOLUTION.zip

2. Change equations for sum descriptions in each of the group footer sections to cut extra words.


Month format code is mmm-yy
Year format code is yyyy

3. Set Width of product category footer descriptive equation to 2.8 inches and Left to 0.2 inches.


4. Delete extra labels with the caption = sum


5. Set width of other group footer descriptive equations to 3 inches.


6. Set Top of sum amount controls to 0 in the group footer sections.


7. Bold header and footer group section controls.


8. Tighten spacing to reduce pages.


9. Set group sections to 'keep header and first record together on one page'.


10. Set Back Color and Alternate Back Color for each section:


- Product Category = aqua
- Day = orange
- Month = blue
- Year = green

11. Set group header and footer controls to Back Style = Transparent.


12. Save, Close, and Rename the report.


13. Modify the menu form to add a command button with a Click [Event Procedure] to open the report in print preview.


Remember to Debug, Compile, and then Save

14. Write VBA code to construct criteria that the user may have picked and ignore criteria that is not specified.


15. Modify the OpenReport code to call the criteria function for the WhereCondition argument.


Remember to Debug, Compile, and then Save

16. Now for the fun part ... open your new report for any date, or date range, or no criteria!

1
 
LVL 16

Administrative Comment

by:Kyle Santos
Great video submission, Crystal!  Congratulations.  Your video has been Approved and is now published on Experts Exchange.  Feel free to share this video by selecting the social sharing icons.
0
 
LVL 21
thank you, Kyle
0
Create a Query and Grouped Report and Modify Design using Access
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final polish on the report, rename it, and add it to a menu form. Download the START and SOLUTION sample databases.

1. Download the START and SOLUTION sample databases (zip file)

SimpleGroupedReport_START_SOLUTION_D.zip

2. Open the START sample database

3. Create a Query to Line Up Data for Report

4. Use the Report Wizard to create a Grouped Report


Source is the query created in step 3

5. Group by year, month, day, then product category

6. Sort by product name then descending amount

7. Specify the amount to be summed

8. Choose Outline layout

9. Modify the Report Design


Add, delete, resize and move controls; show and use different report sections; spacing and boundaries; calculated controls;  formatting and properties; Report View and Print Preview.

10. Compare what you did to the SOLUTION database

1
 
LVL 21
the next video is here:

Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html
0
 
LVL 16

Administrative Comment

by:Kyle Santos
Thanks!
0
Setup SMTP relay to office 365
how to add IIS SMTP to handle application/Scanner relays into office 365.
3
 
LVL 16

Administrative Comment

by:Kyle Santos
acox65807,

Congratulations!  Your video has been Accepted.  Thank you for your contribution to Experts Exchange.  We look forward to seeing more videos from you.  Keep up the great work!
0
How to create an Office 365 email signature using a Transport Rule
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365 users. When this email signature has been created, it will automatically be applied to all outgoing messages via an Office 365 Transport Rule.

Follow the step-by-step instructions below or watch our comprehensive video guide on how to create an Office 365 email signature using a Transport Rule.
7
 

Expert Comment

by:defecta
great vid.

I currently use a VB startup script deployed via GP to control peoples signatures via Outlook but this solution looks like it would work for all users on all devices regardless of client wouldn't it?

If a user sent an email in plain or rich text from Outlook or from an iPhone for example does this sig work still?

And is the signature visible on the users sent items?

You used image URLs in your example. Is it not possible to use embedded images or there a good reason that I am not aware of to avoid embedded images?

Thanks!
0
 

Expert Comment

by:Brad Shepard
The reason you don't have embedded images in these HTML disclaimer transport rules is pretty straightforward -  they don't work.

You can only make it a reference to a public URL unfortunately. As long as the user clicks to

Lastly, the sig won't look right if you email from a device that sends in plain text. Depending on how you've formatting of your HTML and the way the client renders it, the source HTML might actually be visible (it could be a little annoying).

There is third-party software to get around those issues, see www.exclaimer.com 

Alternatively, you could stick with your VB script, but (like you said) it's only going to cover Outlook and only machines where that script has run/can run (so laptops not on the domain might not get the latest signature).

One last point, if you get users to put part of the message body in italics or bold, that *can* get the message to use HTML formatting (so it can render the font style), but it's not guaranteed and you have to rely on end users actually following those instructions.
0
Embedded vs hosted images in email signatures
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it.

The vast majority of email clients display logos/images in an email signature without any major issues, so there might not appear to be much difference between using the two formats. However, there are benefits to choosing one method over the other.
Embedded images

If you want a logo/imagery to appear without having to click a ‘Download Images’ button, we recommend embedding it all within the email signature. This is when an image is attached to an email and referenced using a Content-ID (HTML image tags).

Choose how to present images in email signatures
A standard Content-ID will look like this:

<img src="cid:myimagecid" />

Open in new window


When an email client refers to these images, they will all be displayed automatically. This is because they are referenced in the source of the message.

However, embedded images will slightly increase the size of your emails and there is a slight risk that they will appear as separate attachments in some email clients. There are also known issues with images being stripped out of emails and increasing in size on iOS devices e.g. iPhone and iPad.

Hosted/linked images

If you don't want to run the risk of email signature imagery appearing as attachments, we recommend saving and hosting your logo/images on a web server. They will then…
8
Free Tool: ZipGrep
LVL 9
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

How to tell Microsoft Office that a word is NOT spelled correctly
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When an Office module, such as MS Word, gives us the red squiggly underline signifying a misspelled word, yet it really is spelled correctly (such as a proper noun), we're all familiar with how to add it to the custom dictionary, that is, simply right-click the word and select Add to Dictionary. But suppose we type in a word that does not get the red squiggly underline, that is, Word thinks it is spelled correctly, yet we do not like that spelling, and we want Word (and other Office apps) to flag it as a misspelling. This video explains a Microsoft supported technique for achieving that.

1. Locate the ExcludeDictionary file


Exit all Office apps.

Using Windows/File Explorer (or whatever file manager you prefer), navigate to this file:

c:\Users\<username>\AppData\Roaming\Microsoft\UProof\ExcludeDictionaryEN0409.lex

Of course, <username> is your user name (in my video, it is Joe). The exact name of the file will vary depending on your language and Office version, but it will begin with ExcludeDictionary and have a LEX file extension.

Step1

2. Open the ExcludeDictionary file


Using Notepad (or whatever plain text editor you prefer), open the ExcludeDictionary file, which will be empty the first time you open it. If you do a File>Open, make sure that All Files is selected, since it is a LEX
14
 

Expert Comment

by:baffledbill
Thank you for the detail and writing it in an understandable way.

Based on your information, I played around with the various English files and my locale and language settings and saw it work as you suggested. I also found that it is safe to simply delete the files, and let Office recreate the appropriate one when it performs a spell check.
0
 
LVL 54

Author Comment

by:Joe Winograd, EE MVE 2015&2016
You're welcome, Bill. I'm glad to hear that it works for you. And thanks to you for determining that it is safe to delete the LEX file(s) — that Office will re-create the appropriate one when it performs a spell check. I hadn't tried that — very good to know! Regards, Joe
0
Excel Error Handling Part 3 -- Run and Fix Bugs
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.

Part 1 of this series discussed basic error handling code using VBA.
http://www.experts-exchange.com/videos/1478/Excel-Error-Handling-Part-1-Basic-Concepts.html

Part 2 went in depth on how the VBA  to copy values to blank cells works, and how to loop.
http://www.experts-exchange.com/videos/1498/Excel-Error-Handling-Part-2-VBA-to-Copy-Values-Down-to-Blank-Cells-in-an-Excel-Column.html

Although helpful, it is not necessary to watch parts 1 and 2 before this lesson.

This lesson runs code to see what it does and then breaks working code so we can explore errors.  We run and fix, debug, compile, use and not use Option Explicit, step through code while it is running, look at the watch window to see values of variables, set and clear breakpoints, stop, continue running, and learn how debugging and error handling work.

01. For a list of macros, press Alt-F8


   When you are in an Excel Workbook, press Alt-F8 for a list of Macros.

02. To go to VBA, press Alt-F11


   When you are in an Excel Workbook, press Alt-F11 to go to the Visual Basic Editor (VBE) where you can write Visual Basic for Applications (VBA).

03. To watch variable values, press Ctrl-W


   When you are in VBA code, press Ctrl-W to open the Watch window and set expressions to watch the value of.  If a variable name is highlighted when Ctrl-W is pressed, it will be filled in the Expression.

04. Stop


   Add a Stop statement to the code to cause the code to stop on that line when it runs.

05. To single-step, press F8

1
Excel Error Handling Part 2 -- VBA to Copy Values Down to Blank Cells in an Excel Column
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values where it is blank can be run.

This lesson shows the manual process to fill blanks, and the VBA code to implement it.

This is Part 2 in a 3-part series to discuss error handling in Excel.

Part 3 of this series will add errors to the code and then show how to fix them.  Part 1 of this Experts Exchange series suggested basic error handling code.

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Dimension Variables


   Declare variable names and data types that will be used in this procedure.

03. Initialize Variables


   Initialize the values of variables that will be used in this procedure.

04. Calculate Variables


   Calculate the values of variables that be determined.

05. Give User a Chance to Back Out


   Issue a message box to the user and allow them to stop the process.

06. Determine the Last Row


   Determine the last row on the worksheet that needs to be written to.

07. Loop through each Row of Data and Save or Write Value


   Loop through each row and either save the value that is there, or write the last value saved if a value is needed.

08. Continue Looping until Done


   Continue looping until all values in the specified column are written.

09. Exit Code


   After the procedure code, a line label for the exit code (Proc_Exit: ) is used to signify what happens at the end of the procedure. This is code to gracefully exit.

10. Error Handling Code

0
 
LVL 21
This is Part 2 in a 3-part series to discuss error handling in Excel.  It can be watched independently of the other videos.  This presentation focuses on automating a manual process to copy values from one row to the next in a column of an Excel spreadsheet.

You will learn how to loop through rows using VBA.  This example copies values to blank cells, but you could do something else in your loop.

Part 3 of this series will add errors to the code and then show how to fix them.  
http://www.experts-exchange.com/videos/1518/Excel-Error-Handling-Part-3-Run-and-Fix-Bugs.html

Part 1 of this series reviewed basic error handling code.
http://www.experts-exchange.com/videos/1478/Excel-Error-Handling-Part-1-Basic-Concepts.html

Attached is the download file for this lesson, and the next: Books_ErrorHandling_02_Code2_CopyDownBlanks.xlsm
Books_ErrorHandling_02_Code2_CopyDo.xlsm
0
Excel Error Handling Part 1 -- Basic Concepts
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.

This lesson, Part 1, is the basics.  Whether you are writing VBA for Excel, Access, Word, or another Microsoft Office application,  basic error handling is the same.

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Exit Code


   After whatever your procedure does, a line label for the exit code (such as Proc_Exit: ) is used to signify what happens at the end of the procedure. This can be code to cleanup object variables, or simply code to gracefully exit.

03. Error Handling Code


   After the exit code, a line label for the error handling code (such as Proc_Err: ) is used to begin what happens if there is an error.
Books_START_ErrorHandling_CopyDownB.xlsm
Books_ErrorHandling_CopyDownBlanks_.xlsm
2
 

Expert Comment

by:chris pike
For someone who is trying to wrap their brain around VB for the first time, this video is starting to shed light on the subject.
Well done video, very helpful.

Thanks so much.
I will definitely look out for more videos from crystal (strive4peace).
0
 
LVL 21
thank you, Chris and you're welcome  ~ if you have any questions about basic error handling, please post them here.
0
How to install the Office 2016 desktop applications that come with the free trial of Office 365 Home
In a previous video Micro Tutorial here at Experts Exchange, I explained how to get a free, one-month trial of Office 365, which provides the desktop versions of Office 2016. For Windows, this includes Access 2016, Excel 2016, OneNote 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, and Word 2016, as well as Microsoft OneDrive. The previous tutorial ended at the point of downloading the installer for the Office 2016 desktop modules for Windows. This new tutorial goes through the installation process for those applications.

1. Run the downloaded installer


Using Windows/File Explorer (or whatever file manager you prefer), locate the downloaded installer for the Office 2016 apps that are included as part of the Office 365 Home subscription. The name may vary depending on your operating system, but it will look something like this:

Setup.<lots of other characters here>.exe

Run it (usually, via a double-click, but that depends on your file manager and settings) and then click the "Run" button on the "Security Warning" dialog.

step1

2. Accept the User Account Control dialog


Depending on your User Account Control (UAC) settings, you may or may not get the UAC dialog. If you do, click the "Yes" button.

step2

3. Wait until all Office 2016 apps are installed


Although it says, "We'll be done in just a moment", grab a cup of coffee.

step3

4. Check for the Office Tools shortcuts


Check to make sure that the installer created a "Microsoft Office 2016 Tools" program group, with two shortcuts in it.

step4

5. Check for the Office shortcuts


Check to make sure that the installer created shortcuts for all of the Office 2016 apps. It does not
0
How to get a free trial of Office 365 with the Office 2016 desktop applications
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Personal. However, only one of them offers a free trial — Office 365 Home. This Experts Exchange video Micro Tutorial explains how to go through the process of obtaining the free, one-month trial for Office 365 Home, which includes the desktop versions of Office 2016. For Windows, this includes Access 2016, Excel 2016, OneNote 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, and Word 2016, as well as Microsoft OneDrive. In a subsequent EE video Micro Tutorial, I show how to install the downloaded desktop versions of those Office 2016 modules in a Windows 7 system.

1. Visit the website for Office 365 Home


Visit the site with the only Office 365 edition that currently offers a free trial:
https://products.office.com/en-us/compare-microsoft-office-products

Step1

2. Request free trial


Click the "Try for free" button.

Step2aClick the "Try 1-month free" button.

Step2b

3. Sign into your Microsoft account


Enter your email or phone for your Microsoft account, your password, and click the "Sign in" button.

Step3

4. Go through the payment process


Even though it is a free trial, you must provide a payment method and go through the payment process. So be prepared with a credit/debit card or a bank account or PayPal. If you are unwilling to provide a payment method, you cannot get the free trial.

Step4

5. Go through the install process

0
 
LVL 7

Expert Comment

by:Yashwant Vishwakarma
Thank You for sharing Joe :)
0
 
LVL 54

Author Comment

by:Joe Winograd, EE MVE 2015&2016
You're welcome, Yashwant. I'm glad you like it! Regards, Joe
0
How to delete the Recently Browsed folder list in Microsoft Office Picture Manager
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013, I discovered that Picture Manager itself does not provide the capability to delete items from the Recently Browsed folder list or to delete the list in its entirety. Fortunately, there's an easy way to do it outside of Picture Manager. This video Micro Tutorial explains the method.

1. Locate the OIScatalog.cag file


Open Windows/File Explorer or whatever file manager you use and navigate to this file:

c:\Users\<username>\AppData\Local\Microsoft\OIS\OIScatalog.cag

<username> is the user name, such as Joe in the screenshot below.

Step1

2. Exit Picture Manager and open the OIScatalog.cag file


Close all instances of Picture Manager that are running and then open the OIScatalog.cag file in Notepad or whatever text editor you use.

Step2

3. Delete lines


Delete the lines containing the folders that you want to be removed from the Recently Browsed folder list and Save the OIScatalog.cag file.

Step3

4. Run Picture Manager


Run Picture Manager to verify that the folders have been removed from the Recently Browsed list.

Step4

5. Optional test — delete entire list



Close all instances of Picture Manager that are running and then delete the OIScatalog.cag file. Run Picture Manager to verify that the entire Recently Browsed folder list has been removed.

Step5
That's it! If you find this video to be helpful, please click the thumbs-up icon below. Thank you for watching!
2
How to Install Microsoft Office Picture Manager in Office 2013
Microsoft Office Picture Manager is not included in Office 2013. This comes as quite a surprise to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This video explains how to correct this serious omission by the folks in Redmond and install (for free!) Microsoft Office Picture Manager 2010, which plays very nicely with Office 2013. This video Micro Tutorial is fully documented in my Experts Exchange article, How to Install Microsoft Office Picture Manager in Office 2013.

1. Determine the bit-level of your Office 2013.


Open any Word document (a new, blank one is fine).

To see if you have the 32-bit or 64-bit version of Office 2013, click the File menu, then Account, then About Word.

Step1a
Step1b

2. Download the Microsoft SharePoint Designer.


Download the matching bit-level for your Office 2013 from one of these links:

32-bit
http://www.microsoft.com/en-us/download/details.aspx?id=16573

64-bit
http://www.microsoft.com/en-us/download/details.aspx?id=24309

Step2

3. Run the downloaded SharePoint installer.


Using Windows/File Explorer (or whatever file manager you prefer), execute the downloaded installer and on the opening screen click the Customize button.

Step3

4. Mark all three program sections as Not Available.


Click the drop-down on Microsoft SharePoint Designer and select Not Available.

Click the drop-down on Office Shared Features and select Not Available.

Click the drop-down on Office Tools and select Not Available.

Step4a
Step4b

5. Select Picture Manager to install.


Click the plus sign for Office Tools to expand it.

Click the drop-down on Microsoft Office Picture Manager and select
10
 

Expert Comment

by:pokercrazy
Thank you! The changes to Office 2013 are not the best. I appreciate you putting this together.
Have a good day
0
 
LVL 54

Author Comment

by:Joe Winograd, EE MVE 2015&2016
Hi pokercrazy,
You're welcome! I'm glad you found it helpful. If you wouldn't mind clicking the thumbs-up button under the video window, I'd really appreciate it. You have a nice day, too. Regards, Joe
0

Office 365

5K

Solutions

91

Articles & Videos

3K

Contributors

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.