conditonal copy paste to outlook via excel vba

set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook

in the attached excel, if G3 >10%, copy A3:E3 to outlook

again if G4>10%, copy A4:E4 to outlook

loop G col for every value > 10 ...copy to outlook

send outlook

create a worksheet2 and save the data

Taidot: Excel VBA

Näytä lisää: vba paste into email body, vba insert table into outlook email, copy and paste excel range as picture into outlook email body, vba code to copy and paste data from excel to outlook, rangetohtml, paste excel data into outlook email body, vba copy pivot table into email, how to send a range of cells in an email message vba, copy paste text internet vba, copy paste sort excel, copy paste internet excel manipulate, word open copy paste web page vba, copy paste data excel using visual basic, copy paste values excel spreadsheet, macro copy paste cell excel, copy paste spreadsheet excel websites, copy paste macro excel timed, copy paste report access vba, copy paste protected excel spreadsheet, copy paste values excel

Tietoa työnantajasta:
( 0 arvostelua ) Yuen Long, Hong Kong

Projektin tunnus: #17791624

Myönnetty käyttäjälle:


Dear client I understand what is required in the project. I can surely do this. Please contact me. Roy

$100 USD 2 päivässä
(7 Arvostelua)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Ok . I can do this work

$25 USD 1 päivässä
(0 arvostelua)