98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Word Training and help » Mail merge from two workbooks
Mail merge from two workbooks
Resolved · High Priority · Version 2016
Fri 5 Oct 2018, 10:41Delegate Kerry said...
Kerry has attended:
Excel Advanced course
Mail merge from two workbooks
Hi
I have a spreadsheet with applicants names and their current schools.
I have a separate sheet with the schools' email addresses.
Please could you recommend the best method for me to create a Mail Merge that sends one email to each school and includes all the applicants who attend that school? I assume that I can create a workbook?
Thanks
Kerry
Sat 6 Oct 2018, 10:03Trainer Jens said...
RE: Mail merge from two workbooks
Hi Kerry,
Thank you for the forum question.
I am sorry but Mail Merge cannot do this.
You can use a Vlookup to merge the data to one workbook, but Mail Merge cannot create a list for each school. Mail Merge can send one email for each applicant but this is not what you want of course.
You can write a code in Excel to do it, but then you will need advanced level VBA knowledge.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 8 Oct 2018, 11:34Delegate Kerry said...
RE: Mail merge from two workbooks
Hi Jens
Thank you for your help. Are you able to advise how I would merge the two workbooks with VLook up. I have tried to figure it out but not having much success!
Thanks
Kerry
Mon 8 Oct 2018, 22:09Trainer Jens said...
RE: Mail merge from two workbooks
Hi Kerry,
You will need to have a unique identifier for each school, which can be the school name. In the applicants list you will need a columns with the lookup value which can be matched with the identifier from the school's list.
The data from the school's list can now be looked up to the applicants list by lookup value.
You will need to have a column in each worksheets which are related.
I do not know if this makes sense. I can help you if I can see your files.
You can send them to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 10 Oct 2018, 09:06Trainer Jens said...
RE: Mail merge from two workbooks
Hi Kerry,
I have send you and email with my comments.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Making the first letter of a document bigger (drop caps)Making the first letter of a document bigger than the other text around it gives a document a more 'story-book' look. |
