Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MACROS SETUP
I would like to set up a macro to do the following:
RUN MACRO = SENDING E-MAIL Set up Retreive info from several files (specefic worksheet). Retreive base on number e.g (111-0 or 187-1 etc).Each number has an e-mail address. Format to send as e-mail: 1st TEN rows of the worksheet and rows corresponding with the numbers (117-0) Retreive ONE row above and below numbers Page break if several numbers has the same e-mail within a file/worksheet Page break when retreive info from different file |
#2
|
|||
|
|||
Hi
just as a starting point: http://www.rondebruin.nl/mail/add-in.htm -- Regards Frank Kabel Frankfurt, Germany "titoto" schrieb im Newsbeitrag ... I would like to set up a macro to do the following: RUN MACRO = SENDING E-MAIL Set up Retreive info from several files (specefic worksheet). Retreive base on number e.g (111-0 or 187-1 etc).Each number has an address. Format to send as e-mail: 1st TEN rows of the worksheet and rows corresponding with the numbers (117-0) Retreive ONE row above and below numbers Page break if several numbers has the same e-mail within a file/worksheet Page break when retreive info from different file |
#3
|
|||
|
|||
The site was not helpful
"Frank Kabel" wrote: Hi just as a starting point: http://www.rondebruin.nl/mail/add-in.htm -- Regards Frank Kabel Frankfurt, Germany "titoto" schrieb im Newsbeitrag ... I would like to set up a macro to do the following: RUN MACRO = SENDING E-MAIL Set up Retreive info from several files (specefic worksheet). Retreive base on number e.g (111-0 or 187-1 etc).Each number has an address. Format to send as e-mail: 1st TEN rows of the worksheet and rows corresponding with the numbers (117-0) Retreive ONE row above and below numbers Page break if several numbers has the same e-mail within a file/worksheet Page break when retreive info from different file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros & pie charts | Charts and Charting in Excel | |||
How long have macros been available in Excel? | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
How do you create a macros without overwriting the previous one y. | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |