Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email workbook to multiple individuals with their specific data
Hi, I've been sucessfully using the "Mail a row or rows to each person in a
range (as attachement)" from Rondebruins site (Fantastic site !!!) which emails each individual with only their data found on the spreadsheet. My workbook has expanded resulting in the individuals receiving multiple emails as the macro can only email one sheet at a time. Is it possible to modify the macro to read multiple (not all) pages within the workbook, find the matches and email these sheets in the one workbook? Any help would be much appreciated!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email workbook to multiple individuals with their specific data
Ron has othermacros to do what you wantt. go to webpage below
http://www.rondebruin.nl/sendmail.htm "Tamara" wrote: Hi, I've been sucessfully using the "Mail a row or rows to each person in a range (as attachement)" from Rondebruins site (Fantastic site !!!) which emails each individual with only their data found on the spreadsheet. My workbook has expanded resulting in the individuals receiving multiple emails as the macro can only email one sheet at a time. Is it possible to modify the macro to read multiple (not all) pages within the workbook, find the matches and email these sheets in the one workbook? Any help would be much appreciated!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email workbook to multiple individuals with their specific data
Hi Tamara
Merge the data from the sheets you want in one master sheet and run the mail macro on that master sheet. See http://www.rondebruin.nl/copy2.htm Read the tips below the first macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tamara" wrote in message ... Hi, I've been sucessfully using the "Mail a row or rows to each person in a range (as attachement)" from Rondebruins site (Fantastic site !!!) which emails each individual with only their data found on the spreadsheet. My workbook has expanded resulting in the individuals receiving multiple emails as the macro can only email one sheet at a time. Is it possible to modify the macro to read multiple (not all) pages within the workbook, find the matches and email these sheets in the one workbook? Any help would be much appreciated!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email workbook to multiple individuals with their specific dat
Thankyou for you help.
Each sheet however has different data sets which would cause confusion if the individuals received it on the one page. I've tried to merge the macro I currently use with the one to merge the indiviudals data onto their separate workbooks and then the macro for emailing the entire workbook, but was unsuccessful. I understand if this macro is not possible. Thankyou once again for the advise you've given. "Ron de Bruin" wrote: Hi Tamara Merge the data from the sheets you want in one master sheet and run the mail macro on that master sheet. See http://www.rondebruin.nl/copy2.htm Read the tips below the first macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tamara" wrote in message ... Hi, I've been sucessfully using the "Mail a row or rows to each person in a range (as attachement)" from Rondebruins site (Fantastic site !!!) which emails each individual with only their data found on the spreadsheet. My workbook has expanded resulting in the individuals receiving multiple emails as the macro can only email one sheet at a time. Is it possible to modify the macro to read multiple (not all) pages within the workbook, find the matches and email these sheets in the one workbook? Any help would be much appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the curser is highlighting multiple cells instead of individuals | Excel Discussion (Misc queries) | |||
Email/Mail Merge document lines to specific multiple recipients | Excel Discussion (Misc queries) | |||
Email notification including specific cell data | Excel Worksheet Functions | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Using VB, specific cell data into email subject | Excel Discussion (Misc queries) |