How do you use Excel to create memorandums?

2019-06-15T13:14:59-04:00

I'm pretty good with Excel, but creating macros (and pivot tables) are outside my forte. Has anyone made an Excel sheet that creates a word document in memorandum format? If anyone has one, please let me know! I'm looking to create one.

Response by SFC Marc W. made Jun 15 at 2019 1:25 PM

2019-06-15T13:25:22-04:00

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

Response by MAJ Private RallyPoint Member made Jun 15 at 2019 6:12 PM

2019-06-15T18:12:55-04:00

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.

Response by CWO3 Private RallyPoint Member made Jun 21 at 2019 9:09 AM

2019-06-21T09:09:18-04:00

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.

Response by Elvira Valdez made Jan 8 at 2025 10:27 AM

2025-01-08T10:27:20-05:00

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.

Just a moment...