Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List - Hyperlink - Template - Email
Hi Wise Ones...
A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List - Hyperlink - Template - Email
** CORRECTION **
1) auto hyperlink ea ref no. COLUMN A .... Hi Wise Ones... A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List - Hyperlink - Template - Email
"SteveT" wrote:
** CORRECTION ** 1) auto hyperlink ea ref no. COLUMN A ... Hi Wise Ones... A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email hyperlink | Excel Discussion (Misc queries) | |||
How to Hyperlink in an email? | Excel Discussion (Misc queries) | |||
Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
Email via hyperlink | Excel Discussion (Misc queries) | |||
email using hyperlink | Excel Worksheet Functions |