How do you use Excel to create memorandums?

The answer is coding it in VBA, the programming language shared by all Microsoft products. The base code would be in excel which is the source of your data (I assume). I’d create a VBA module in excel that would generate a Microsoft word template for whatever you are doing and execute code to place values from your data into your Microsoft word document. Then I would just use a macros button in excel probably right on your data spreadsheet that you would just click on when you have finished inputting your data. The button just executes the coding module previously described, and boom, instant memo with the right names and info. Not sure what organization you are in, but if you have ORSAs near you, then can help you set that up. Most of us are quite familiar with VBA. Also if you have any computer science types around you, they should know VBA.

Better off using word. You can get a template easily and much easier to manipulate in a word processor.

You can put links in cells to whatever you want. Create in Word and post a link to it in cell of spreadsheet. Spreadsheets are not user friendly for wordsmithing.

You can use VBA in Excel to create a Word document for your memorandum. Set up your data in Excel, like recipient, subject, and body, then write a macro to populate a Word template with those details. Once it’s ready, you just click a button, and the memo gets generated.
If you’re new to VBA, this is a great project to learn the basics. https://excel.tv/best_excel_books/ has some solid resources to help you get started with automating tasks like this. It’s a useful skill for making processes like this quick and easy.