Hi



Is it possible to run a macro that would email the print area in "letter" tab to all pupils listed in the second ab to the parent emails field?

Thanks in advance

Attached Files

USERNAMES.xlsx (6.9 KB, 9 views)

Have a look at this - i have used it multiple times in the past

Mail Range/Selection in the body of the mail

you basically save the letter page as a temp HTML doc then send it out. you will need to loop through all the email address and possibly the letter if it is unique to each pupil

It might be simpler and would certainly produce better presented results if you created the merge document in Word and use mail merge to e-mail. To that end see E-Mail Merge Add-in which will allow to merge to the body of the message, or to an attachment in Word or PDF format.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com