Excel Online: is there a mail-merge equivalent to produce reports?

%3CLINGO-SUB%20id%3D%22lingo-sub-51726%22%20slang%3D%22en-US%22%3EExcel%20Online%3A%20is%20there%20a%20mail-merge%20equivalent%20to%20produce%20reports%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-51726%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20student%20results%2C%20where%20each%20student%20has%20several%20grades%20for%20different%20assessment%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20produce%20reports%20for%20each%20individual%20student.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20past%20I%20have%20used%20a%20Mail%20Merge%20for%20this%2C%20and%20also%20Excel%20VBA%20to%20produce%20PDF%20reports.%20Neither%20of%20these%20options%20work%20using%20Excel%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20Office%20365%20tool%20that%20will%20allow%20me%20to%20generate%20reports%20based%20on%20a%20template%20from%20Excel%20Online%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-51726%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262825%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3A%20is%20there%20a%20mail-merge%20equivalent%20to%20produce%20reports%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262825%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20such%20experience%20without%20using%20VBA.%20In%20that%20case%2C%20I%20need%20to%20copy%20a%20lot%20of%20worksheet%20(Template%20Report)%20and%20then%20use%20the%20class%20no%20for%20the%20vlookup%20to%20lookup%20student's%20result%20in%20their%20report.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262712%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3A%20is%20there%20a%20mail-merge%20equivalent%20to%20produce%20reports%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262712%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20love%20this%2C%20too.%26nbsp%3B%20This%20is%20very%20easily%20accomplished%20with%20Google%20Sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2152640%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3A%20is%20there%20a%20mail-merge%20equivalent%20to%20produce%20reports%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152640%22%20slang%3D%22en-US%22%3EIf%20you%20have%20creative%20cloud%20and%20Adobe%2C%20you%20can%20convert%20the%20pdf%20to%20Word%20and%20insert%20text%20boxes%20where%20you%20would%20like%20to%20enter%20in%20names%20of%20students%20or%20marks.%20Then%20go%20to%20mailings%20and%20link%20to%20your%20excel%20data%20then%20do%20mail%20merge%20to%20pdf.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a spreadsheet with student results, where each student has several grades for different assessment items.

 

I need to be able to produce reports for each individual student.

 

In the past I have used a Mail Merge for this, and also Excel VBA to produce PDF reports. Neither of these options work using Excel Online.

 

Is there any Office 365 tool that will allow me to generate reports based on a template from Excel Online data?

3 Replies

I would love this, too.  This is very easily accomplished with Google Sheets.

I had such experience without using VBA. In that case, I need to copy a lot of worksheet (Template Report) and then use the class no for the vlookup to lookup student's result in their report. 

 

If you have creative cloud and Adobe, you can convert the pdf to Word and insert text boxes where you would like to enter in names of students or marks. Then go to mailings and link to your excel data then do mail merge to pdf.