Office 365 Tips
Mail Merge allows you to create multiple documents based on information contain in two different files. You鈥檒l need the main document (e.g. a letter), and a data source (e.g. list of addresses) from Excel or Outlook Contacts. Then follow the instructions below to produce a merged document with these files using Mail Merge.
- In Word, open your main document such as a letter or the content of an e-mail. If creating labels, start with a blank new document.
- Click on Mailings > Start Mail Merge >Step-by-Step Mail Merge Wizard鈥
- The Mail Merge Wizard will open as a Task Bar to the right of the document. Select
the document (Letters, E-mail messages, Envelopes, Labels or Directory) you would like to create
- Click on Next: Starting document at the bottom of the Mail Merge Task Bar
- At Step 2, select the following option if you are
- Creating letters or e-mails: Select Use the current document. This step will make sure the opened document will become the main document in the process
- Creating labels: Select Change document layout and click on Label options鈥
- Under Tray, select Manual Feed (Place your label paper facing up on the manual feed tray of your printer and open the rear output tray)
- Under Label vendors, make sure Avery US Letter is selected.
- Then under Product number, find the label that matches the label number on the Avery label box.
- Click on OK.
- Click on Next: Select recipients
- At step 3, select one of the two options below
- If using an Excel list, select Use an existing list, then click on 叠谤辞飞蝉别鈥 Find your Excel file and click on Open
- If using Outlook Contacts, click on Select from Outlook contacts and Choose Contacts Folder. Select your contact folder from the list and click on OK
- Click on OK to complete the selection of the list
- Click on Next: Write your letter or e-mail message (if creating an e-mail)
- At step 4, click on the main document to position the cursor where the Merge Fields will be added. If the main document are labels, the cursor will be at the first label by default. Just add the Merge Fields there
- With the cursor in place, click on More items鈥 Double click on all the Merge Fields needed to complete your document. When done,
click on the X to close
芦贵颈谤蝉迟冲狈补尘别禄芦尝补蝉迟冲狈补尘别禄芦厂迟谤别别迟1冲尝颈苍别1禄芦颁颈迟测禄芦厂迟补迟别禄芦窜颈辫冲颁辞诲别禄 - Next, click in between each merge field, outside the chevron symbols (禄触芦), and add spaces and any punctuation needed to separate the Merge Fields (see below)
芦First_Name禄 芦Last_Name禄
芦厂迟谤别别迟1冲尝颈苍别1禄
芦City禄, 芦State禄 芦Zip_Code禄 - Click on Next: Preview your letters, Labels or e-mail message to do just that. Use the arrow buttons between Recipient on the Task Bar to preview the information from the data source in your main document.
- Click on Next: Complete the merge
- Select one of the following option depending on what you are creating
- If creating letters or labels
- Click on Edit individual letters鈥 and OK. This option will open your merged document in a new document. Check the information for accuracy.
- The last step is to either Print or Save the document for later use
- If creating e-mail messages
- Click on Electronic Mail鈥
Important: Make sure your Outlook client is opened and you are logged on with the appropriate account (e.g. your office account). Word will use this account to send the e-mail messages - At the To prompt, select the Merge Field containing the e-mail addresses.
- Enter a Subject line and click on OK. The process will take a few minutes to complete, depending on the size of the list.
Outlook 365 - Sending Large Attachments
File sizes have grown over the years; however, not all e-mail service providers have kept up with attachment limits. Sending a file larger than your recipient's file size limit may prevent your message from reaching their inbox. Before sending out an e-mail with a large attachment (> 5 MB), consider using the OneDrive online storage provided with your Office 365 membership to share files as a link.
Attaching your File
Once you have your message and file ready, find the "Attach" menu and choose the "Cloud Locations" option.
Next, choose the option "Computer" to instruct the OneDrive tool to look at local files, then browse for and select your file.
You'll be prompted to choose how to attach your local file. Confirm that you wish for the file to be uploaded to OneDrive and attached as a link.
Once your file has finished uploading, you'll see it attached as a OneDrive link. Your recipient will be able to download the file as long as it exists within your OneDrive storage.
For more information on Microsoft OneDrive and using it to store, share, and collaborate on your files, check out the course on !
Backing up data is an important part of managing your digital content, and here at 淫性视频 all files saved to your My Documents folder are automatically backed up to 淫性视频鈥檚 servers. This protects your work from accidental deletion, corruption, or hardware failure, and gives you access to it from any 淫性视频 computer that you鈥檙e currently logged in to.
In this example of how to save your work to your 淫性视频 network backup folder, we鈥檒l be using any component program of the Microsoft Office Suite.
With your document open, click on the File tab.
Next, choose the menu entry 鈥淪ave As鈥, followed by 鈥淏rowse鈥. This option will allow you to navigate to and choose your 鈥淢y Documents鈥 backup folder as the storage location for your document.
Keeping your documents backed up is critical to data security, and lost work is lost time! Nobody wants to re-write a syllabus from scratch, or to lose batches of data collected in the field. Additionally, if you鈥檙e ever off-campus and need a document, you can access this folder by logging into 淫性视频鈥檚 VDI, a virtual desktop service that operates on 淫性视频鈥檚 network.
For tips on moving your existing files over to the local backup folder, check out this handy video course !
Reply All is the default option when replying to messages in Outlook on the Web for Office 365. You can select Reply by clicking on the down arrow to the right of Reply all, but when responding to an e-mail, Reply all is the default option.
To change the default option on your account to Reply rather than Reply all, follow the instructions below:
- Go to Outlook on the web from the 淫性视频 Portal or at and sign in
- On the top right, click or tap on Settings
- Under Your app settings, select Mail
- To the left, under Options, Mail, Automatic processing, click or tap on Reply settings
- Select Reply under Make my default response
- Click or tap on Save
The response button will now change to Reply
Groups are the new and improved option in Office 365 for sending e-mails to multiple people. They replace Contact Groups (formerly known as Distribution Lists) and also include powerful collaboration features.
Use Groups in Office 365 to collaborate with and easily set up a collection of resources with 淫性视频 users to share. Adding members to the group automatically gives them the permissions they need to the tools your group provides.
The instructions below will show you how to create Groups in Outlook.
- Open Outlook 2016.
- Do one of the following to start a new Group:
- Outlook 2016 Client. Select Home > New Group.
- Outlook on the Web. In the navigation pane (left), below your Folders, next to Groups, select the + button. (If you have a long folder list, you'll need to scroll down until you see Groups.)
- Outlook 2016 Client. Select Home > New Group.
- Fill out the group information.
- Group name: Create a name that captures the spirit of the group.
- Once you enter a name, a suggested email address is provided. "Not available" means the group name is already in use and you should try a different name. Note that once you choose a group name, it cannot be changed.
- Description: Optionally, enter a description that will help others understand the group's purpose. This description will be included in the welcome email when others join the group.
- Classification: Choose a classification. Options available depend on what your organization has set up.
- Privacy: By default, Groups are created as Private. This means only approved members in your
organization can see what's inside the group. Anyone else in your organization who
is not approved cannot see what's in the group.
- Select Public to create a group where anyone within your organization can view its content and become a member.
- Select Private to create a group where membership requires approval and only members can view group content.
- Send all group conversations and events to members' inboxes Optionally, check this box to enable members to see all group conversations and events in their inbox without having to visit separate group workspaces. Members can change this setting for their own mailboxes.
- Select Create.
You can now use your Group in an e-mail just like a distribution list
Add Members to your Groups
- Your Groups are accessible from your Folder List. Just scroll down to Groups and click on the arrow to expand it.
- Select your Group
- On the Groups ribbon, select Add Members
- In the Add Members dialog box, under Add people, search for the new member and click on his/her name to add the account to the Members list
- Click on OK when finished
Remove Members from your Groups
- Your Groups are accessible from your Folder List. Just scroll down to Groups and click on the arrow to expand it.
- Select your Group
- On the Groups ribbon, select Add Members
- Under Members, point at the person's name and click on the X to the right
- Click on OK when finished
Let Flash Fill help you enter data faster and more accurate. It predicts the rest of the data based on the first entry posted. Below are different ways you can take advantage of this feature in Excel.
Separate First and Last Name
If you have a list of names in one column, Flash Fill allows you to quickly separate the names in different columns. In the example below, I want first and last name to be in their own columns.
- Create first and last columns to the right of Names (See picture below)
- Enter the first names. As soon as you start typing the second "First" name, Flash Fill will preview a list, predicting how you want to fill the column
- Just hit the Enter key to complete the rest of the column
Fill a Formula to Adjacent Cells
Flash Fill can also copy formulas by dragging the Fill Handle (bottom right)
- Enter the formula and hit Enter
- Click on the formula to select the cell
- Point at the Fill Handle (bottom right) until the pointer changes to a black plus sign
- Click & hold and drag the Fill Handle across the cells you want to fill
Quickly Enter Months of the Year or Days of the Week
- Enter the month or day
- Click on the month or day
- Click & hold on the Fill Handle
- Drag the Fill Handle across the cells you want to fill
Distribution lists make it easy to reach out to many organization members at once. Membership, however, is not an automatic process and must be managed manually.
To begin, open up your web browser and access Outlook Web. Find and click on the Settings (Gear-shaped) icon. Then, click on the entry 鈥淢ail鈥.
Next, in the left-hand menu, click on 鈥淕eneral鈥 and then 鈥淒istribution Lists鈥. Under
鈥淒istribution Lists I Own鈥 double-click on the name of the group you鈥檇 like to make
changes to.
You鈥檒l be brought to the details pane of the group, click on 鈥淢embership鈥 to manage
the users included on the distribution list. Click on the plus (+) icon to add members
or click on member names followed by the minus (-) icon to remove members.
When you click on the plus (+) icon to add members, you鈥檒l be brought to a search
page. Enter a last name and click on the magnifying glass to search for a user. Click
the plus (+) icon to the right of a person鈥檚 name to add them to the list of users
to be enrolled in the distribution list. Click Save 鉁旓笍 in the top-left of the search
window when you鈥檝e finished choosing new members.
Click Save to finalize changes made to the group鈥檚 membership.
Microsoft Teams is a versatile messaging platform designed to connect users and facilitate the quick exchange of ideas and content. Comparable services include Slack and Google Hangouts. Try using Teams to communicate with your colleagues, it鈥檚 included in your 淫性视频 Office 365 subscription!
To begin, open up your web browser and navigate to . Log in using your 淫性视频.edu e-mail address.
You鈥檒l be brought to the main Teams window. From here, you can create Teams, which function similarly to a group chat, or go to the Chats pane, which allows you to message users individually.
In the Chats pane, you can search for individual users by first name, last name, or e-mail address.
Teams is great for sharing content; when you鈥檙e composing a message, click on the 鈥淎ttach鈥 icon to send any type of file, whether it鈥檚 to one person or a Team chat!
Microsoft Teams is also available for your smartphone! Get it on or in the .
To download the Microsoft Teams client on your 淫性视频 desktop or laptop, open the Software Center and click on the Teams icon.
For additional Information on maximizing your Microsoft Teams experience, check out this .
If you expect to have limited e-mail access, it鈥檚 a good idea to set an Out of Office message to alert students and coworkers who may be attempting to reach you. In the Outlook Web interface, this can be enabled indefinitely or set to operate only until a specific date and time.
To begin, open up your web browser and navigate to , next, log in with your Go淫性视频 credentials and click on the e-mail icon at the top-right corner of the GoPortal. Sign into your e-mail with your full firstname.lastname@stockton.edu address.
You鈥檒l be brought to the main Outlook window. From here, click on the Settings icon.
Choose the option 鈥淎utomatic Replies鈥.
In this menu, you can turn on Automatic Replies, designate start and end times for the replies, and compose Automatic Replies for 淫性视频 and (optionally) non-淫性视频 e-mail addresses.
For additional information on Outlook on the web, check out Lynda.com鈥檚 .
Groups are the new and improved option in Office 365 for sending e-mails to multiple people. They replace Contact Groups (formerly known as Distribution Lists) and also include powerful collaboration features.
Use Groups in Office 365 to collaborate with and easily set up a collection of resources with 淫性视频 users to share. Adding members to the group automatically gives them the permissions they need to the tools your group provides.
The instructions below will show you how to create Groups in Outlook.
- Open Outlook 2016.
- Do one of the following to start a new Group:
- Outlook 2016 Client. Select Home > New Group.
- Outlook on the Web. In the navigation pane (left), below your Folders, next to Groups, select the + button. (If you have a long folder list, you'll need to scroll down until you see Groups.)
- Outlook 2016 Client. Select Home > New Group.
- Fill out the group information.
- Group name: Create a name that captures the spirit of the group.
- Once you enter a name, a suggested email address is provided. "Not available" means the group name is already in use and you should try a different name. Note that once you choose a group name, it cannot be changed.
- Description: Optionally, enter a description that will help others understand the group's purpose. This description will be included in the welcome email when others join the group.
- Classification: Choose a classification. Options available depend on what your organization has set up.
- Privacy: By default, Groups are created as Private. This means only approved members in your
organization can see what's inside the group. Anyone else in your organization who
is not approved cannot see what's in the group.
- Select Public to create a group where anyone within your organization can view its content and become a member.
- Select Private to create a group where membership requires approval and only members can view group content.
- Send all group conversations and events to members' inboxes Optionally, check this box to enable members to see all group conversations and events in their inbox without having to visit separate group workspaces. Members can change this setting for their own mailboxes.
- Select Create.
You can now use your Group in an e-mail just like a distribution list
Add Members to your Groups
- Your Groups are accessible from your Folder List. Just scroll down to Groups and click on the arrow to expand it.
- Select your Group
- On the Groups ribbon, select Add Members
- In the Add Members dialog box, under Add people, search for the new member and click on his/her name to add the account to the Members list
- Click on OK when finished
Remove Members from your Groups
- Your Groups are accessible from your Folder List. Just scroll down to Groups and click on the arrow to expand it.
- Select your Group
- On the Groups ribbon, select Add Members
- Under Members, point at the person's name and click on the X to the right
- Click on OK when finished
To mitigate the effects of a bug which exists in the interactions between iOS鈥檚 calendar and Events created in Outlook, IT Services recommends that you install and use the official Outlook app to use with your 淫性视频 e-mail address. Additionally, the Outlook app offers several features not available in the default Mail client such as Focused Inbox and the ability to view shared calendars.
To begin either on your phone, or open up the App Store on your iOS device and search for 鈥淢icrosoft Outlook鈥.
Open up your newly-downloaded Outlook app and log in with your full 鈥渇irstname.lastname@stockton.edu鈥 e-mail address.
If you鈥檇 like to compare the experience of Focused Inbox, you can toggle it on and off in the Settings menu. To access the Settings menu, tap at the menu icon in the top-left of the screen and navigate to Settings 鈥 denoted by a gear icon. Once in the settings menu, you can access features such as Signature customization and how swipe actions function.
To access your Calendar, leave the Settings menu and tap on the Calendar icon at the bottom of the screen.
While in the Calendar view, you may add shared calendars by tapping on the menu icon in the top-left of the screen, then on the option 鈥淎dd Shared Calendar鈥. Enter the shared account e-mail address you鈥檇 like to add and click on the + icon.
So long as your account is authorized to access that shared calendar, events from that calendar will now be visible in your Outlook app.
Phishing is any attempt to disguise electronic communications with the intent to defraud
and acquire information such as usernames, passwords, or credit card details. As computer
networks become hardened against online attacks, social engineering has become a more
potent vector and an attractive target for criminals. 淫性视频 takes network
security seriously and asks that you notify staff of any phishing attempts you receive.
If you have received a message directing you to reply with or otherwise enter personally identifiable information online, please report the message as a phishing attempt (phishing@stockton.edu) or use the phish alert button which reports the phishing solicitation to the Information Security team (this button automatically appears in your Outlook and Office 365 clients).
The Phish Alert button will also delete the suspicious email from your mailbox to
prevent any future exposure. We all play a critical role in keeping institutional
data secure and to aid in this task, we ask that you take a skeptical approach to
any solicitations that seem suspicious. 淫性视频's Information Technology
Services will never ask you to disclose your password (via email or otherwise).
If you suspect that you鈥檙e being targeted, please notify information.security@stockton.edu via email or by calling (609) 652-4779.
Additionally, if you feel unsure about an email message sent from a member within the 淫性视频 community, please reach out to them or their unit directly for clarification (before clicking on included links or opening suspicious attachments).
You can now record your computer screen and audio with Screen Recording in PowerPoint for Office 365, 2016. You have the option of adding the recorded video to a PowerPoint presentation or you can save it as a separate file to create a screencast.
Record from your computer screen and embed the recording in PowerPoint
- Start PowerPoint.
- Open the slide where you want to add the screen recording on.
- On the Insert tab, click/tap on Screen Recording.
- A pop up menu will open (the Control Dock) Tap/click Select Area.
- Point the cross-haired cursor at the top left of the area you want to record, then click and drag to select the area.
- By defaul, the Audio and the Record Pointer are selected on the Control Dock for recording. You can turn them off by just clicking on those options.
- When Ready, click Record. (Unless you pin the Control Dock to the screen, it will slide up into the margin while you record. To make the unpinned Control Dock reappear, point the mouse cursor at the top edge of the screen.)
- As you record the screen, you can do the following:
- Click Pause to temporarily stop the recording (Windows logo key+Shift+R):
- Click Record to resume recording (Windows logo key+Shift+R).
- Click Stop to end your recording (Windows logo key+Shift+Q).
- When you are finished recording, save your presentation: File > Save. The recording will be embedded on the slide on your PowerPoint presentation.
To save the recording itself as a separate file on your computer, right-click on the recording, and select Save Media As. In the Save Media As dialog box, specify a file name and folder location, then click Save.
Set your video Start settings
In your PowerPoint presentation, right-click the video frame, click Start, and pick how you want your video to start in your presentation
Trim your video
- Right-click the video frame, and click Trim.
- Slide the Markers or use Start Time, End Time to cut out portions of the video at the begining and the end of the clip
- When done, tap/click on OK
Apply a style to the video frame
In your PowerPoint presentation, right-click on the video, click Style in the Control Dock menu, and pick a style.
E-mail is one of the most reliable forms of communication at 淫性视频. All faculty, staff, and students are provided with an e-mail address, and it produces a record for both the sender and the recipient. Often it can be burdensome to address e-mails to many recipients, however with e-mail lists you can reach your entire class with a single message!
To begin, either open your Outlook desktop client or mobile app, or log into Outlook Web in your web browser. Class e-mail lists are only available to @stockton.edu e-mail address associated with a course鈥檚 instructor, they will not relay your message if it originates from a personal e-mail address e.g. gmail, yahoo mail, aol.
When using your class e-mail list, the address is formatted as:
[semester][year]-[school][course][section]@stockton.edu
For example, a 2019 Fall Semester course, GEN-1000-091, would be addressed as
鈥 fall2019-gen1000091@stockton.edu 鈥.
Any messages sent to these lists will be relayed to all students currently registered for the course in Banner, this does not include waitlisted students. These lists are automatically generated and will self-update as students register and de-register.
Keeping track of tasks can be a job of its own when working across platforms. Microsoft To Do integrates with Outlook and other Microsoft Office suite products and can help centralize your list of To-Do鈥檚!
Our first step is to sign in, you鈥檒l need to log in at with your 淫性视频 e-mail address and GoPortal credentials.
Once you鈥檙e logged in, you can begin creating Tasks. Click on the 鈥 + Add Task 鈥 button to make your first task.
Once a task has been created, you can make changes to individual Task settings by clicking on the task and working in the right-hand side Task Properties menu.
Additionally, a task can be assigned 鈥淪teps鈥 or discrete sub-tasks. Each step can be marked as complete individually.
Tasks can also have reminders and due dates set, each can use predetermined dates or have custom dates and times entered.
A key feature to To Do is its ability to share data across Microsoft products 鈥 for example, Tasks can be created, viewed, and modified in their own Tasks tab in Microsoft Outlook.
A task list is fundamentally a basic concept, but To Do鈥檚 power lies in its integration across other tools. For more information on how to leverage To Do and make task tracking easier for you, check out .
Adding or updating your profile photo is a fun way to personalize your @stockton.edu e-mail address. When setting up your profile picture, please be sure to use a work-safe and friendly image!
Our first step is to sign in: you鈥檒l need to log in at with your 淫性视频 e-mail address and GoPortal credentials.
Next, locate your user icon at the top-right corner of the screen. If you have not set a profile picture before, it will appear as your first and last initials. Click on the user icon, and you鈥檒l be brought to the 鈥淢y account鈥 menu.
In the 鈥淢y account鈥 menu, hover over the expanded user icon and you鈥檒l see the outline of a camera appear. Click on that camera and you鈥檒l be brought to the 鈥淐hange your photo鈥 dialog box.
Click on 鈥+ Upload a new photo鈥 to choose an image file from your computer.
Once you鈥檝e uploaded your photo, you can use the zoom slider below your new profile
picture to adjust its size. Additionally, once zoomed in you can click and drag to
reposition the picture within its circle of visibility. Click 鈥淎pply鈥 and then 鈥淒one鈥
to finalize your changes, and your new profile picture will begin to appear alongside
your @stockton.edu e-mails!