Macro mail merge excel to excel

[samyscraps01]

Hi,

I have an excel document for a performance evaluation. This is an actual evaluation form in excel that can be printed. This document has multiple fields, say Name, ID, Job Code, Job Title, Etc. Every Department within the organization has multiple employees. So, in Dept. 130000 say I have 10 employees rather than pre-populating this spreadsheet for each employee and printing it out 10 times. I was told someone ran a macro and did this all at once. Meaning an Excel spreadsheet with all the data was mail merged into this excel document and it created multiple tabs with their names and the cells already populated with the data on it. I have no idea how to do this and I can no longer find the person that did this. Is there anywhere I can start?

Help!

Thanks.

 

[Macropod]

What you're trying to do is not a mailmerge. Regardless, the person who created the macro may have left it in the workbook. Did you check what macros it contains (e.g. via Alt-F8)?

 

[samyscraps01]

I looked under F8 and F11. There is nothing but I think that's likely because the document i'm looking at is the one that was duplicated not the original. So, a file was created in excel that contained a "template" that template allows you to populate cells, like names, id’s numbers, etc. There was also a secondary separate excel file containing a basic report with employee data, Names, ID, Job Titles, Etc. The whole point of this report was to take the data and populate the template. Say the report contained five employee names and their data as described above, he wrote a command that created 5 separate copies of that template with the employee already populated in it. So, he managed to create a personalized template for each person using a macro with the data on that report. I don’t know if this is part of it but it also renamed the tabs with their last names. Not sure how he did that. I don’t know coding very well, and I’ve only used macros a handful of times. Nothing this complex. I cannot find a source online or on youtube that will walk me through something like this. I haven’t found anything remotely close to what I’m trying to achieve.

 

[samyscraps01]

One more thing...the reason I thought it was a mail merge is because he titled the file mail merge docs.

 

[Macropod]

If it was for a mailmerge, one would expect there to be a Word mailmerge main document that drives the process, not an Excel macro or an output worksheet.

Without access to the workbook, it would be difficult for anyone here to write the applicable Excel code. Although you can't attach workbooks, here, we do have tools that allow you to post snapshots. See 'Posting Aids' in: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html