Bearing in mind I have no clue about VBA or Macros, could someone end my
agony. I have a large data set and need filter data by a single column
(owner) and then magically email to each "owner" their particular data. I
have filtered the data, so no problem with that. But how do I get the
particular owners data to him, without sending any of the other data too. I
need to automate this entire process as I will have to do this quarterly.

Thank you so much

ctrl+G
press Special
Visible cells only
copy
paste as values to another workbook
File-Send to

HIH

Jenny,

There is one more way to do this.
Say for eg. Select the cells having owners data
then ctrl+C, Ctrl+N,Ctrl+V
then save the file with the owners name, once the file is saved in the
owners name you can open the file and click File/Send/As email Attachement.

Please let me know your feedback
--
Thanks
Suleman Peerzade


"Jenny Smit" wrote:

Bearing in mind I have no clue about VBA or Macros, could someone end my
agony. I have a large data set and need filter data by a single column
(owner) and then magically email to each "owner" their particular data. I
have filtered the data, so no problem with that. But how do I get the
particular owners data to him, without sending any of the other data too. I
need to automate this entire process as I will have to do this quarterly.

Thank you so much

Thank you so much for your reply Suleman, I am aware of this, but how to
automate it without having to do this repeately for 1000's of owners, is what
I am trying to do. There must be a way to do it once and then have office do
it for the rest. Thank you again

"Suleman Peerzade" wrote:

Jenny,

There is one more way to do this.
Say for eg. Select the cells having owners data
then ctrl+C, Ctrl+N,Ctrl+V
then save the file with the owners name, once the file is saved in the
owners name you can open the file and click File/Send/As email Attachement.

Please let me know your feedback
--
Thanks
Suleman Peerzade


"Jenny Smit" wrote:

Bearing in mind I have no clue about VBA or Macros, could someone end my
agony. I have a large data set and need filter data by a single column
(owner) and then magically email to each "owner" their particular data. I
have filtered the data, so no problem with that. But how do I get the
particular owners data to him, without sending any of the other data too. I
need to automate this entire process as I will have to do this quarterly.

Thank you so much

Hi Jenny

See
http://www.rondebruin.nl/mail/folder3/row2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jenny Smit" <Jenny wrote in message ...
Bearing in mind I have no clue about VBA or Macros, could someone end my
agony. I have a large data set and need filter data by a single column
(owner) and then magically email to each "owner" their particular data. I
have filtered the data, so no problem with that. But how do I get the
particular owners data to him, without sending any of the other data too. I
need to automate this entire process as I will have to do this quarterly.

Thank you so much