Vba code to send pages from an excel document by email!

[Liam88]

Hi all,

I’ve been tasked to try and see if I can make distributing pages from an excel spreadsheet easier.

I need to be able to send around 70 different pages from excel to 70 different peoples email address. Is it possible to create vba code that at the click of a button sends an email with the page to an email address contained on that page? The person is happy to click a button for each page that needs to be sent.

Hope someone can help.

Liam

 

[Logit]

.
Everything Email with Outlook and Excel. The "go to website" for assistance.

https://www.rondebruin.nl/win/s1/outlook/mail.htm