Session 4 - Mail Merge

 Mail Merge

In today's class, we will look at how we can integrate the Office applications seamlessly (well almost), and in particular, integrating into Word.

We will start with the humble Mail Merge.

Access

I have created this simple database using a template and have added some contact information. This is what it looks like:



We will use this file to create a MS Word Email Merge.







Create your email message


Use the Wizard to continue to the next step and to finally create your email merge.



The principle is the same whether it is an email merge or an actual mail merge with labels or envelopes. Nowadays, though, email merges are much more common than the old fashioned letter drop.

Excel


Mail Merge with excel is very similar. Follow the Step by Step Wizard, select your spreadsheet as the source, and select the recipients.



Mail Merge Activity

Follow the steps to complete an email merge with the spreadsheet and the database.

Sorting in Word

One might think - "why do I need to know how to sort in Word, we have Access for that?" Well yes, but if you have a small list of items that you are writing as you think of them, you can use the sort feature to organise the items.

If your information is in a table it is very simple, just click on the sort button in the table layout.

The sort table dialog box will appear and you can select the sort column - simple.








But what about sorting text that is not in a table. This is easy as well.


This is the same document, but it has been converted to text paragraphs using the Convert To Text feature.






To sort paragraphs, use the sort button on the Home ribbon paragraph section.







Moving Paragraphs

As well as sorting paragraphs, you can very quickly move paragraphs up and down within a document. Using the same example, rather than sorting the paragraphs, you can move them up or down until they are in the correct spot. To do this, click in the paragraph that you want to move, use the keyboard shortcut of Shift+Alt+Up or Shift+Alt+Down key.

Status Bar

The Word status bar is actually very useful and quite customisable. The Status Bar is located at the bottom of the screen (just in case you didn't know what it is called).


The left side of the status bar has:
  • Page Number/Go To
  • Word Count/Word count dialog box
  • Proofing errors/Correction
  • Language / Change Language
  • Macros


The Right hand side of the status bar has:
  • Document View options – Print, Full screen, Web, Outline and Draft
  • Document Zoom.
Use Right-Click on the Status Bar to add or remove items from the bar.



Other Office Tools - Sway

Sway provides a different take on the traditional PowerPoint presentation and Sways are designed to be viewed online.











Some Sway Resources...

https://www.howtogeek.com/404119/what-is-microsoft-sway/

https://support.office.com/en-us/article/getting-started-with-sway-2076c468-63f4-4a89-ae5f-424796714a8a

https://www.youtube.com/watch?v=pcg6DGO9hpI

https://www.youtube.com/watch?v=mZFnRVwgOOM

Class Activity

Try creating a short Sway and share on our Diploma group page.


Comments

Post a Comment

Popular posts from this blog

Lesson 16 - Service level Agreements and troubleshooting

Image
What is a Service Level Agreement? A service-level agreement (SLA) defines the level of service expected by a customer from a supplier, laying out the metrics by which that service is measured, and the remedies or penalties, if any, should the agreed-on service levels not be achieved. Usually, SLAs are between companies and external suppliers, but they may also be between two departments within a company. Source:  https://www.cio.com/article/2438284/outsourcing-sla-definitions-and-solutions.html Read the above article on Service Level Agreements (SLAs).  Class Activity 1 ITIL describes 3 types of Service Level Agreements (SLAs). You can read about them here  https://www.givainc.com/blog/index.cfm/2018/12/3/3-Types-of-Service-Level-Agreements What are the 3 types of Service Level Agreements? What type of SLA would be relevant for South East TAFE? Why? What type of SLA would be relevant for Mysty River Regional Library Service (MRRLS)? Why? What things should be detai...
Read more

Lesson 13 - Peripherals and components

Image
Peripheral Devices A peripheral device is defined as a computer device, such as a keyboard or printer, that is not part of the essential computer (i.e., the memory and microprocessor). These auxiliary devices are intended to be connected to the computer and used. Types of Peripheral Devices  Peripheral devices can be external or internal. Examples of external peripherals include mouse, keyboard, printer, monitor, external Zip drive or scanner. Examples of internal peripherals could include a DVD or CD reader/writer, but there are not very many internal devices that would be considered peripherals these days. Today's new devices, such as tablets, smartphones and wearable computing devices are considered peripherals as they can be connected and used on a computer system. The difference, however, is that these devices can run independently of the computer system, unlike a computer mouse, for example. https://www.webopedia.com/TERM/P/peripheral_device.html External Perip...
Read more

Lesson 14 - Virus protection, security and helpdesk communications

Image
Staying Safe online There are a range of tools that you can install that offer various levels of virus protection, security protection, malware protection and/or Virus and malware removal. You can install multiple products or you can install a suite that will cover most of the tools necessary. The following articles provide good information for staying safe online. Links to Australian Government Cyber Security information Department of Home affairs - Cyber Security portfolio eSafety Website  - Office of the eSafety Commissioner Australian Institute of family studies - Online Safety Australia.gov.au Cyber Security information  List of government/industry projects  https://www.scamwatch.gov.au/   list of current scams and alerts Australian Cyber Security Centre  - links to a variety of online security information Information for businesses I guess this shows that we are taking cybercrime and online security relatively seriously! Virus P...
Read more