ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Àx¦s®æ¶W³sµ²¹q¤l¶l¥ó³]©w

Àx¦s®æ¶W³sµ²¹q¤l¶l¥ó³]©w

½Ð°Ý¦U¦ì¤j¤j¡G
·Q¦bEXCELªºÀx¦s®æ¤¤³]©w¶W³sµ²¡A
¶W³sµ²¤¤ªº¹q¤l¶l¥ó³]©w->¥D¦®  ¡A·Q­n¦Û°ÊÅã¥Ü¥Á°ê¦~¤ë¡C
¤]´N¬O»¡³]©w¦n¤§«á¡A¥u­nÂI¸ÓÀx¦s®æ¡A·|¦Û°Ê«Ø¥ß¹q¤l¶l¥ó¡A
¥B¹q¤l¶l¥óªº¡u¥D¦®¡vÄæ¦ì·|¦Û°ÊÅã¥Ü¥Ø«eªº¥Á°ê¦~¥÷¤Î¤ë¥÷¡AEX: ¦Û°Ê§ì¨ú105¦~2¤ë¥÷¡A©Ò¥HÅã¥Ü105-2
½Ð¦U¦ì¤j¤jÀ°À°¦£¡AÁÂÁÂ

§Aªº·N«ä¬O¤£¬OÄæA(¦pA2)¿é¤J"¥D¦®A",
«hÄæB(¦pB2)¥X²{ "¥D¦®A 105¦~2¤ë" ?
¦pªG¬O, ¸Õ¸Õ:
B2=IF(A2="","",A2&" "&TEXT(NOW(),"e¦~m¤ë")) ¤U©Ô

TOP

¥Î¶W³sµ²µo°eEmail


20160224-01(¥Î¶W³sµ²µo°eEmail).rar (2.07 KB)
1

µû¤À¤H¼Æ

    • ML089: ¤S¦³·s©Û¡A­È±o¹ªÀy¡AÆg OUTLOOK ¶·¨Ï¥Î¤À ...ª÷¿ú + 2

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-2-25 05:07 ½s¿è

ÁÂÁ­ã¤j, ¦nªF¦è­n¦n¦nªº¦¬ÂÃ, ÁÂÁÂ!!
(«Øij¥t©ñ¤À¨É)

TOP

¥Ø«eÁÙ¬O¤p¾Ç¥Í(§V¤O¤Éµ¥¤¤)¡A
ÁÙ¤£¯à¤U¸üªþ¥ó¡A
¤£¹LÁÙ¬O«ÜÁÂÁ­ã¤jªº¦^µª¡A
·P®¦~~

TOP

¦^´_ 5# takeshilin88

¥t¤@¤U¸ü§}¡G
http://www.funp.net/715484

TOP

¦^´_ 3# ­ã´£³¡ªL

§Ú¨Ï¥ÎOUTLOOK ±H¥ó¤H¤À¹j²Å¸¹¬°¤À¸¹  ;

½Ð°Ý ªþ¥ó ­n¦p¦ó³]©w¡A§Ú¨Ï¥Î¤U¦C¤è¦¡µLªk¦¨¥\¡A­þ¸Ì­n­×§ï? ÁÙ¬OOUTLOOK¤èªk¤£¦P?
=HYPERLINK("mailto:"&A2&"?subject="&B2&"&body="&SUBSTITUTE(C2,CHAR(10),"%0A") & "&attachment=D:\TEST.TXT" , "µo«H")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


SUBSTITUTE(C2,CHAR(10),"%0A") ¬O±N¡e´«¦æ²Å¸¹¡f¨ú¥N¦¨"%0A"
­Y¥H¥H";"¬°¤À¹j¡A«h¬°SUBSTITUTE(C2,";","%0A")¡I

TOP

¦^´_ 6# ­ã´£³¡ªL


   

­ã¤j±z¦n¡G
·PÁ±z´£¨Ñªº¤U¸üºô§}~~
­Y¬O¤w¦b½s¿è¶W³sµ²/¹q¤l¶l¥ó¦a§}¡A¤w³]©w¦nmail«H½c¡A
1.¨º¸ÓÀx¦s®æªº¤½¦¡HYPERLINK¬O§_¥i¥H¤£¥[mailto¡H
2.ÁÙ¬O¥i¥Hª½±µ¦b½s¿è¶W³sµ²//¹q¤l¶l¥ó¦a§}/¥D¦®¸Ì¡Aª½±µ³]©w¤½¦¡©O¡H
ÁÂÁÂ~

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-2-26 09:47 ½s¿è

¦^´_ 9# takeshilin88

¥u­n¡e¥D¦®¡f
=HYPERLINK("mailto:?subject="&B2, "µo«H")

¤@¯ëªº¶W³sµ²¡AÀ³µLªk³]¤½¦¡§a¡I

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD