Quote:
Originally Posted by macropod
Try the attached workbook. I've implemented the mcrImport & mcrCombine macros. The macro assumes the National & State files are all kept in the same folder.
You still haven't provided anything relevant to the mcrValidate macro and your WelcomeAboard template, though, would be better implemented as a mailmerge main document, for which no macros would be required.
|
Morning. While mail merge would probably be the best solution and I trust your knowledge. I have been told by the admin manager that a macro is required. I can't unfortunately make any changes to the outlined request as they come from a subsidiary company.
So in regards to the mcrValidate. I was given the following information.
In row 1 of sheet Combined the following column headings: Last name, First name, Gender, DOB, Address, Suburb, State, Postcode, Role, Category.
Standardise all fonts to plain Arial 12 pt.
The column Category in sheet Combined was not in the original states data. Its purpose is to record the age category for each member.
The various categories from Junior to Great Grand Master
Junior - Under 18
Senior - 18+
Master - 40+
Grand Master - 50+
Great Grand Master - 60+
For each member data, generate the age category for column Category. for each row subtract DOB from your Nationals date to find the member's expected age on the day of competition, then compare with the category table below. Write out the category data for the member in full.
I hope this helps. You have already helped immensely and I do appreciate it.