Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto send spreadsheets as email attachments
I have a list of names in cells A1:A10 on a sheet tab called 'Names'. On
another sheet tab called 'Data', I have a range of data with an autofilter, where column A includes these names, and columns B thru Z contains other data. What I'd like to do is write code that will take each name on the list, filter the data for that name, then automatically send the filtered data as an email attachment to that person. It would then cycle through until the whole list is completed. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Macro to send email from Excel and add other attachments | Excel Programming | |||
Send an email, some with/without attachments | Excel Discussion (Misc queries) | |||
Auto Send email from IF command | Excel Worksheet Functions | |||
Can Excel auto-send an email on a given date? | Excel Discussion (Misc queries) | |||
how can i send email with attachments paths (3 workbooks) located in the cell a1 to a3 | Excel Programming |