send sheet as email

**kobiashi** · 04-13-2018, 05:11 AM

Hi

I'm not having much luck trying to find a VBA script for what i want, hopefully somebody can point me in the right direction

I have a spreadsheet that have events entered onto it, these events are date based, what i want to do is,

the user presses a button, a pop up box appears asking for a date, when the user inputs a date, it then pulls all the data from the sheet, in table form, based on that date and pastes it into an email.

**Norie** · 04-13-2018, 05:23 AM

Sounds pretty straightforward, which part(s) are you having problems with?

**kobiashi** · 04-13-2018, 05:49 AM

LOL

Well all of it really, im not that experienced with VBA, so i normally look for a script understand how it works, and then adapt it, but i havent found a script i can use

**Norie** · 04-13-2018, 05:55 AM

Well you're looking at 2 separate things here, first the part to pull the data, probably to a new sheet, and second emailing the sheet.

You'll find code to at least get you started on the second part here.

The first part is probably more specific to how you have things set up, any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.