Civinfo - View Single Post

TTDegs · 19th October 2006, 17:06

many thanks for all the replies!

I've actually taken inspiration from each of them, scratched my head a lot, perused the (fairly useless!) help topics, and come up with...

macros copies relevant data into new worksheet

B1 contains the report title = "Report for 2006/10/18"
B3 contains (dynamically) the email address of the recipients
C3 contains (dynamically) the store name

Code:

emailstore = range("b3").value
emailsubj = range("b1").value + " - " + range("c3").value
activeworkbook.sendmail Recipients:=emailstore, subject:=emailsubj

and job is jobbed

MANY thanks again for all the replies - much appreciated!

19th October 2006, 17:06	#8 (permalink)
TTDegs Super Moderator Civinfo master Join Date: 4th August 2006 Location: Cardiff Posts: 5,634 Thanks: 0 Thanked 1 Time in 1 Post iTrader: (0)	many thanks for all the replies! I've actually taken inspiration from each of them, scratched my head a lot, perused the (fairly useless!) help topics, and come up with... macros copies relevant data into new worksheet B1 contains the report title = "Report for 2006/10/18" B3 contains (dynamically) the email address of the recipients C3 contains (dynamically) the store name Code: emailstore = range("b3").value emailsubj = range("b1").value + " - " + range("c3").value activeworkbook.sendmail Recipients:=emailstore, subject:=emailsubj and job is jobbed MANY thanks again for all the replies - much appreciated!