Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Email specific fields in a worksheet
Hello,
I am stuck working on a new macro. Currently, I have a workbook that emails each worksheet to a specific user (based upon an email address referenced on each worksheet in field B2. This works great, however, the new project I am working on has one worksheet (200 entries) that I need to email each user but only data on the sheet that relates to the specific user. For example, the size (23 Columns x 13 Rows) are exactly the same for each user. A1:W13 (with B3 containing the email address) A14:W26 (with B16 containing the email address) A27:W39 (with B28 containing the email address) I could setup 200 worksheets and have the block of data (23 Columns x 13 Rows) on each worksheet and use the code I have to email each sheet, however, it is much too hard to manage that many sheets. Basically, code should look for an email address, if found, select rows -2 (up two from email address found) through 11 (total of 13 rows) copy into email and send to email address specified. Does that make sense? Any assistance would be helpful. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to add row in same worksheet based on 2 fields not having a | Excel Programming | |||
Email Macro specific Cells? | Excel Worksheet Functions | |||
macro to copy specific fields to another worksheet | Excel Programming | |||
macro to send excel sheet to specific email address | Excel Programming | |||
applying a macro for a specific field to a range of fields | Excel Programming |