Using Excel to create the body of an Outlook e-mail
February 24, 2010 9:24 PM Subscribe
Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that!
posted by doh ray mii to Computers & Internet (1 answer total)
I'm creating a workbook with a feature that copies a range of cells into the body of an Outlook e-mail message.
I have the VBA to generate an Outlook e-mail from Excel, and I have the VBA to run a macro based on simply selecting a cell in a certain column - all of this falls in line with what I need.
What I don't have is the VBA to, based on the selection a cell, copy a range of cells.
For instance: I select cell "J8", and cells "A8:H12" are copied. Or if I select cell "J20", cells "A20:H24" are copied.
Preference is for this to be accomplished via VBA.