Office 365

8K

Solutions

4K

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 Office 365 Backup and Restore Solution - Trend You Need To Know
Microsoft Office 365 Backup and Restore Solution by SysTools to export Office 365 mailbox to PST / EML file format on Windows OS. On Mac, tool backup O365 to PST / MBOX / MSG / EML / EMLX file formats. Not only this, restore option helps to import single as well as multiple PST file back to Office 365 tenant.

Visit Official Site to Know More: https://www.systoolsgroup.com/office365-backup/

1. Download & Install.

Visit the official site to "Download & Install" Microsoft Office 365 Backup and Restore software by SysTools

2. Login Using Office 365 Credential

Enter username & password and click on "Login" button.

3. Select File Format

Select PST or EML file format to backup Office 365 mailbox in that particular format

4. Apply Date Range Filter

This option is provided to backup Microsoft O365 Mailbox within a particular date range.

5. Export Button

Click on "Export" button to start the backup process.
0
Microsoft Azure 2017
LVL 12
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

How to recover deleted emails from Office 365 portal and through MFCMAPI
Please check the video also in regards to recovery of deleted emails from office 365 admin center and through the MFCMAPI tool.

I have mentioned each and every step with the proper steps that need to be taken care of.
0
Office 365 Basics. Module 6 - Office Online
Learn how to collaborate with office 365 Office Online
0
Office 365 Basics. Module 5 - OneNote
See the Basics of Office 365's Note Taking app, OneNote
0
LVL 10

Author Comment

by:Alan Cox
I will be. I will also be adding more content to the OneNote 2016. e.g. tagging, OneNote/Outlook integration, ect.
1
LVL 4

Expert Comment

by:Kathy Jacobs
LMK if you have questions or need help. Used to be a OneNote MVP. Know you have  lots of other good sources too.
1
Office 365 Basics. Module 4 - Skype For Business
Learn the basics of Skype For Business in office 365
0
Office 365 basics. Module 3 - Outlook 2016
Discover the basics of using Outlook 2016 from office 365.
0
Office 365 Basics. Module 2 - OneDrive
Overview of OneDrive and collaboration.
0
Office 365 Basics Module 1 - Overview of portal
Basic Overview of office 365 user portal
0
Wrapper-2, VBA.  Show result of Excel Worksheet Function in Access Query
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access.

The declaration statement defines the function name and its return data type. The values it needs to calculate are specified as parameters, or arguments.

Create an error handler that will exit without the user realizing there might have been a problem, and define a default value of zero for the function return value.

See how to open Excel and refer to it so code in Access can use it. Reuse the Excel application object to make susbsequent processing faster ... so, how do we clean that up?

Use the function in a query! Part 1 shows a query with the calculated column that calls this code:
Wrapper-1-Query-Show-result-of-Excel-Worksheet-Function-in-Access-Query.html

Even though topics may be technical, I do my best to consider that a beginner may be watching, so extra detail is added. Hopefully not so much that more advanced users turn away ... maybe you will comment and let me know your thoughts about this? Thanks!

have an awesome day,
crystal

1. Dimension oExcel as object at top of module

2. Name of function follows the "Function" keyword

3. Enclose function parameters in parentheses

4. Declare data type of return value

5. Set up error handler


For more information on the error handling, here is a short video: Basic-Error-Handling-code-for-VBA-and-Microsoft-Office.html

6. Define default return value

7. Validate parameters -- not done in this example

8. See if Excel is loaded and ready to use


if not, then open Excel in the background and use oExcel to represent it

9. Call the Excel function you want and pass parameters

10. Assign the result to the function return value

0
Wrapper-1, Query.  Show result of Excel Worksheet Function in Access Query
Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a query in Access that has a calculated column with the results of an Excel worksheet function.

See how to call a wrapper function from a query, and send the information it needs. "Wrapper Function" is a term to mean a user-defined function (UDF) that calls another program. In this case, Excel is called and one of its worksheet functions is used. This example shows  payment calculations for a number of offers from data that is stored in a table (loan amount, annual interest rate, number of years, and number of payments per year) using Excel's PMT function.

Also see how query columns can display in different colors using the format code, and learn about some of the placeholders.

Part 2 shows how the VBA code works:
Wrapper-2-VBA-Show-result-of-Excel-Worksheet-Function-in-Access-Query.html

Even though topics may be technical, I do my best to consider that a beginner may be watching, so extra detail is added. Hopefully not so much that more advanced users turn away ... maybe you will comment and let me know your thoughts about this? Thanks!

have an awesome day,
crystal

1. Create a query with the fields you want

2. Define calculated fields with intermediate calculations if desired

3. In the calculated column with results from a VBA wrapper function, specify the function name


Send fields, calculated fields, and literal values as parameters inside parentheses

4. To color data in the column, use [ColorName] in the Format property


The color name in square brackets can be Black, Blue, Green, Cyan, Red, Magenta, Yellow, or White

5. Format codes have 4 parts separated with semi-colon (;)


1. Positive, 2. Negative, 3. Zero, 4. Null (vs Text in Excel)
0
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Subform to show Calculations in Microsoft Access
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.

A Microsoft Access subform is used to show relevant calculations for data in the mainform.

A subform control is a container, like a bucket, for a form or report. Its properties specify: what it contains (Source Object), how it is linked (Link Master Fields, Link Child Fields), what it is called (Name), how big it is (Width, Height), where it is  (Top, Left), what it looks like (Border Color, Border Style, Special Effect), whether or not it shows (Visible), if the user can modify values (Locked, Enabled), and so on.

As you navigate from record to record in the mainform, data in the subform automatically changes. LinkMasterFields and LinkChildFields are used to synchronize the forms, without any more effort on your part!

On the mainform, LinkMasterFields is a combobox that stores CustomerID but shows the customer name and more. What is displayed in the combobox is influenced by Column Count, ColumnWidths, and ListWidth.

The form inside the subform control is a regular form designed to be used as a subform; and in this case, to display information only, so things like RecordSelectors and ScrollBars are turned off. The RecordSource for the subform (where it gets its data from) is a query that has 2 queries below it doing more calculations. See how queries are stacked to get …
0
How to set up a global email signature in Office 365 and add it only to new emails
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online)

The email signature template has been downloaded from:
https://www.mail-signatures.com/articles/signature-templates/?sts=6630

If you prefer a written article to the video, go to:
https://www.mail-signatures.com/articles/configuring-organization-wide-email-signatures-in-office-365/?sts=6630

For more advanced email signature features, check out CodeTwo Email Signatures for Office 365:
https://www.codetwo.com/email-signatures/?sts=6630
0
Mainform + Subforms designed for efficiency and flexibility
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. When a sale is made, it may be paid outright, carried in-house, or purchased by a finance company.

Using a mainform with subforms allows data entry into multiple tables with referential integrity. There are also calculations, and ways to find and filter information; Synchronizing subforms so they update with the record changes using LinkMasterFields and LinkChildFields; Calculating sum and total number of orders and payments, and the balance due; Displaying the company logo; and more.

Learn how to undo creating a new record, use shortcuts and quick ways to enter data, and about setting the Enter key behavior in the Access Options so pressing Enter goes down one row, just like in Excel. See how easy it can be to disburse all the is remaining on an allocated amount left to a single order.

See how Anchoring subforms and controls enables them to stretch and shrink as the display area changes.

Future lessons will go into the nuts and bolts of how this form works, address issues, fix problems (there are some), and enhance capabilities.

~~~

Did you learn something new?

Please Like, Comment, and Share with your friends. Thank you.

Through sharing, we will all get better.

have an awesome day,
crystal

1. Download sample database

0
How to Create Calendar Reports from Access Queries
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.

Visualize your data!  ... really see it

To use the code to create a calendar from a query, simply import the (only) module (mod_HtmlCalendarReport_s4p) from the download (see Step 1, below)  into your working database (and then compile and save, of course). You can get the same code by choosing File, Import in the VBE (Visual Basic Editor -- Alt-F11) and choosing the BAS file.  

Importing VBA doesn't, of course, include easy-to-launch macros (even though the macros run VBA procedures) ... triggering them is a snap -- especially if you use a menu form with buttons and other controls.  

Please, as you make changes, rename the 'test' procedures to have more meaningful names depending on how you customize them and how they are used. And add your own comments ... and indent?

If you feel like sharing, your ideas are welcome, and appreciated.

Using vba:
Application.FollowHyperlink Create_HtmlCalendar(sQueryName)
  • will open a web page with the calendar created from the query specified by sQueryName
  • The Create_HtmlCalendar function creates the calendar as an HTML file (web page)
  •   it returns the path and filename when done.
  • You have a calendar file you can email and share with others.
  • you may wish to add VBA Error Handling (Basics video)

What do you need to know to use this feature?
2
display Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased, or a down triangle if it decreased ... and stagger the markers for even greater grasp.

This lesson also covers how to handle non-American date formats, and optimize performance with a subquery.

If you like this video, please Like, Share, and Comment ~ thank you

1. Make a new query based on a table (MyData) with a date (TheDate) and a value (Price)


   - add date and value fields to the grid
   - sort in decending order by date

2. Add another copy of the table to the query


   - Access will '_1' to the end of the name of the copy at the top of the fieldlist to make it unique.
   - This table will represent the record for 'yesterday',  or whenever the previous value was recorded.
   - add date and value fields to the grid and give them aliases (for instance, PrevDate and PrevPrice) since field names have to be unique

3. Create a calculated field to show the difference


   - for instance --> Diff: CCur( MyData.Price - MyData_1.Price )
   - between a value in the reference record and the previous record
   - Wrap with function to convert to currency to ensure the result is the correct data type
   - the calculated field name (alias) is 'Diff' since it appears before the colon

4. Create a calculated field to show the Unicode symbol corresponding to a Circle or Triangle to graphically represent the difference

0

Expert Comment

by:Andy Brown
Nice work Crystal - thank you for sharing.
1
LVL 24
thank you, Andy

Unicode:

Note: Some fonts have more, and better, Unicode representations than others. For Windows standard built-in fonts, Arial Unicode MS and Lucida Sans Unicode have fair coverage.  Common fonts such as Arial, times New Roman, and Calibri can be okay too.

If you cannot show the Unicode characters used to demonstrate, try these instead:

filled circle  --> 9679

down-pointing triangle --> 9660

up-pointing triangle --> 9650
0
How to export Office 365 mailboxes to PST using eDiscovery
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on that topic here).
0
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
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
1
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
JavaScript Best Practices
LVL 12
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

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 19

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 24
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 24
the next video is here:

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

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 19

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

Office 365

8K

Solutions

4K

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.