ࡱ> 9;8[ bjbj 4*ΐΐ66}}}}}4:$( "R}}}:}}V@C/02:5  0:Ax#l.##}:#6 C: Project Name: emailing using Excel as Data Base The Macro or Software should run using Excel and Outlook in MS Office 2007 as well as MS Office 2003 R0) The function will send an email to all the registers (lines) in the Excel Data Base where the email addresses for each record is in the email column (column X) for those registers that includes 1 in the flag column (Column Y). The email (Column X) and flag (column Y) columns have to be a parameter in the menu when the software starts running. Other columns in the Excel spreadsheet are variable information for the emails sent. The email body has to be a .txt file that has to be selected at the time the software starts with the email and flag columns. This email body has to call the variable data included on each Column of the Excel spreadsheet using & column name& command. The Excel Data Base should also be selected at the menu when the software starts. The email font has also be requested and selected from the menu The email signature has also be requested to be included or not in a check box in the menu Summary: RO is like the email merge from MS Word using Excel as a data base for the variable data as well as email addresses and the flag column to decide which emails should be sent R1) The menu should have the following options (click Box or something similar) R 1.1) No file attached R 1.2) Attach a File to the emails (Same file for all the emails) R 1.3) Attach Personalized File to the emails R 1.1) No File Attached: The Macro or Software operates as R0 R 1.2) Attach a File to the emails (Same file for all the emails sent) The menu has to include the selection of the file name to be included as attach in the emails. The software has to send the selected file attached to the email as per R0 function The file has to be any kind of file (Extension) R 1.3) Attach Personalized Files to the emails The menu has to request for this option the File Directory where all the personalized files to be attached are located. Filenames in the File Directory will match with the Excel filename column where each line has a different file name. The Filename in the Excel_Data_Base DOES NOT include extension: The file to be selected and sent is the one, regardless the extension, that match the filename in the Excel_Data_Base. A process can include different file extensions BUT only One file attached per Excel line. Could exist some lines in the Excel_Data_Base without filenames for this R1.3. No files will be attached for this records ANNEX Please find attached the following information: Menu.doc: Example of the Menu EXAMPLE N1 Excel_data_base01.xls : Example Excel data base Message_body01.txt : Example of Message Body associated to the Excel_data_base01.xls file Email01.txt: Example of one of the emails sent using Message_body.txt as well as the Excel_data_base01.xls data base. This example is for the line 5 which is the only one on this example that has 1 in the Flag column. This is the result of the R0 including option R1.1 EXAMPLE N2 Message_body02.txt : Example of Message Body associated to the Excel_data_base02.xls file Excel_data_base02: Example of the more complex Excel_Data_Base File for the R1.3 requirement and files attached that has to be sent in the email. Email02.txt : Example of one of the emails sent using Message_body02.txt as well as the Excel_data_base02.xls data base. This example is for the line 5 which is one of the lines that has 1 in the Flag column. This is the result of the R0 including option R 1.3 for that line. 37Tlo 1 ^ s t u | }  J e f 5 ǷǷǷǷǷǷs_'h$ht5CJOJQJaJmH sH h'CJOJQJaJmH sH htCJOJQJaJmH sH ht+CJOJQJaJmH sH 'h*h*5CJOJQJaJmH sH h2GCJOJQJaJmH sH h*CJOJQJaJmH sH *h2Gh*5>*CJOJQJaJmH sH $h*h*CJOJQJaJmH sH "3 K H 5 = Y X <=lm\gd$gd*  < = A G H ] c d z {    ȸؤؤظؤ؄s__'h$h$5CJOJQJaJmH sH !h$5CJOJQJaJmH sH h*CJOJQJaJmH sH h &|CJOJQJaJmH sH 'h &|h &|5CJOJQJaJmH sH h$CJOJQJaJmH sH h$CJOJQJaJmH sH $h*h*CJOJQJaJmH sH 'h$h*5CJOJQJaJmH sH ./4=>ACl[9:Wjp|ȴȡȴȡqhbcCJOJQJaJmH sH h=CJOJQJaJmH sH h$CJOJQJaJmH sH $h*h*CJOJQJaJmH sH 'h$h$5CJOJQJaJmH sH 'h$h*5CJOJQJaJmH sH !h$5CJOJQJaJmH sH $h$h*CJOJQJaJmH sH $\p >?Rb   gd= & FgdR & FgdR & Fgd'^h^hgd'^ & Fgd=^gd\gd\ & Fgd(gdbcgd*  >?FRbhjĴjWGWG7GWh'^CJOJQJaJmH sH h(CJOJQJaJmH sH $h=h(CJOJQJaJmH sH *h\h\5>*CJOJQJaJmH sH 'h\h\5CJOJQJaJmH sH h\CJOJQJaJmH sH h6VdCJOJQJaJmH sH h=CJOJQJaJmH sH $h*h*CJOJQJaJmH sH *h=h=5>*CJOJQJaJmH sH $h=5>*CJOJQJaJmH sH  abrsںqq^q^q^qNh*CJOJQJaJmH sH $h=h*CJOJQJaJmH sH h=CJOJQJaJmH sH $h=h'^CJOJQJaJmH sH *hDxhDx5>*CJOJQJaJmH sH h(CJOJQJaJmH sH h'^CJOJQJaJmH sH hRCJOJQJaJmH sH $h Eh ECJOJQJaJmH sH $h Eh(CJOJQJaJmH sH 68\]    ݽݭz$h=hLYCJOJQJaJmH sH h#CJOJQJaJmH sH hLYCJOJQJaJmH sH h=CJOJQJaJmH sH h_KCJOJQJaJmH sH hP+CJOJQJaJmH sH hRCJOJQJaJmH sH $h EhRCJOJQJaJmH sH gd=21h:p^v. A!"#$% j 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ OJPJQJ_HmH nH sH tH J`J ^vNormal dCJ_HaJmH sH tH NA N Fuente de prrafo predeter.RiR 0 Tabla normal4 l4a ,k , 0 Sin lista D@D 2l Prrafo de lista ^m$N N J Sin espaciadoCJ_HaJmH sH tH PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!&lTRtheme/theme/theme1.xmlYMoE#F{oc'vGuرHF[xw;jf7q7J\ʯ AxgfwIFPA}H1^3tH6r=2%@3'M 5BNe tYI?C K/^|Kx=#bjmo>]F,"BFVzn^3`ե̳_wr%:ϻ[k.eNVi2],S_sjcs7f W+Ն7`g ȘJj|l(KD-ʵ dXiJ؇kZov[fDNc@M!͐,a'4Y_wp >*D8i&X\,Wxҕ=6.^ۄ Z *lJ~auԙՍj9 !bM@-U8kp0vbp!971 bn w*byx$پ,@\7R(=Q,)'KQk5qpq Qz,!_ Y4[an}`B-,#U,ђMpE`35XYd״?%1U9إ;R>QD DcNU'&LGpm^9+ugVh^n<*u7ƝSdJ9gn V.rF^*Ѕ҈}-p !:P5gyڧ!# B-;Y=ۻ,K12URWV9$l{=An;sVAP9zszH'[`ۇ@PbW<{ˆ1W+m_SsncY̕([ @}`g >V?4hf6՗t#M&ʺ6'B gks:\qN-^3;k ] =Y42&0GN|tI&MI`=DCPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!&lTRtheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  *  \ t@# AA@0(  B S  ?p  v {  3333 ?  ((,yq.8:0j"^`OJPJQJ^Jo(-^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hH8^8`o(()^`. L^ `L. ^ `.x^x`.HL^H`L.^`.^`.L^`L.^`o(()^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.0j.8((ܳ/                B         5$> U V< 5*#t^vP+dK1\4= EJE qE V'^6VdLl`rqwt=v4xDx &|bcMF2l9!_K,N/$Rt+J*LY\c'$w(\=2Gccc~\@ / X@UnknownG* Times New Roman5Symbol3. * ArialA. Trebuchet MS7.{ @Calibri?= * Courier New;WingdingsA BCambria Math"qr=&=& * * !202QHX  $P2l2!xx jvaldiviaa jvaldiviaa   Oh+'0t  0 < HT\dl jvaldiviaa Normal.dotm jvaldiviaa13Microsoft Office Word@캃@Ԭ&0@i/0* ՜.+,0 hp  Banco de Chile  Ttulo  !"#$%&')*+,-./1234567:Root Entry Fpi!/0<1Table4#WordDocument4*SummaryInformation((DocumentSummaryInformation80CompObj}  F+Documento de Microsoft Office Word 97-2003 MSWordDocWord.Document.89q