µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» CDO MESSAGE ¶Ç°eEMAIL®É¡A¹ï ¤è¦¬¨ì¥X²{¤¤¤å¶Ã½X¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
CDO MESSAGE ¶Ç°eEMAIL®É¡A¹ï ¤è¦¬¨ì¥X²{¤¤¤å¶Ã½X¡C
dechiuan999
µoµu®ø®§
¥[¬°¦n¤Í
dechiuan999
·í«eÂ÷½u
UID
1016
©«¤l
231
¥DÃD
55
ºëµØ
0
¿n¤À
293
ª÷¿ú
293
ÂI¦W
0
§@·~¨t²Î
winxp
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
KEELUNG
¦b½u®É¶¡
41 ¤p®É
µù¥U®É¶¡
2010-7-24
³Ì«áµn¿ý
2018-8-28
¤¤¾Ç¥Í
©«¤l
231
¥DÃD
55
ºëµØ
0
¿n¤À
293
ÂI¦W
0
§@·~¨t²Î
winxp
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
KEELUNG
µù¥U®É¶¡
2010-7-24
³Ì«áµn¿ý
2018-8-28
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-3-26 09:54
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
CDO MESSAGE ¶Ç°eEMAIL®É¡A¹ï ¤è¦¬¨ì¥X²{¤¤¤å¶Ã½X¡C
¦U¦ì¤j¤j¦n¡G
¤p§Ì¨Ï¥Îhinet
¨Ã³z¹Lcdo¶Ç°e«H®§
¦Ü¹ï¤è¡C¥i¬O¹ï¤è¦¬¨ì
«H®§®É¤¤¤å·|¥X²{¶Ã½X
¨Ò¦p¡G
subject:CDO ¶l¥ó´ú¸Õ
HTMLBODY:¶l¥ó¥»¤å
¹ï¤è¦¬¨ì«H®§¦p¤U
subject:CDO ?
HTMLBODY:?
·P®¦¤j¤j¡I
Sub sendmail()
Dim objEmail As Object
Const SMTPSERVER = "msa.hinet.net" '¨Ï¥Î msa.hinet.net ¶Ç°e¶l¥ó
Set objEmail = CreateObject("CDO.Message") '«Ø¥ß CDO ª«¥ó
With objEmail.Configuration.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = SMTPSERVER
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With
objEmail.From = "
[email protected]
" '±H¥óªÌ¡]ºô°ì¥²¶·¦s¦b¡^
objEmail.To = "
[email protected]
" '¦¬¥óªÌ
objEmail.Subject = "CDO¶l¥ó´ú¸Õ" '¶l¥ó¥D¦®
objEmail.HTMLBody = "¶l¥ó¥»¤å" 'HTML¶l¥ó¤º¤å
objEmail.Send
Set objEmail = Nothing
End Sub
½Æ»s¥N½X
¼Ó¥D¼ö©«
¹ïC»y¨¥¦p¦óÀ³¥ÎªººÃ´b
®a¸Ì¹q¸£ºô¸ôµLªkµn¤J³Â»¶®a±Ú
¦p¦ó°Ï§ONumberFormat¤ÎNumberFormatLocal¨Ï
¦p¦ó±NA5¯È±i®æ¦¡¤@¦¸¦C¦L©óA4¯È±iª½±µ²£¥Í
¦p¦ó¦b«ü©wªº©w¸q¦WºÙ¤º«ü©w½d³ò¥[Á`©O¡H
¬°¦óTextboxªºSetfocusµLªkµo´§¥\¯à©O¡H
¬°¦ó°õ¦æexcel vba¤§«á«H¥ó¤´°±¦boutlook±H
¦p¦óÅýListbox¥i¤@¨ÖÅã¥Ü¤u§@ªíªºªíÀY©O¡H
¦p¦ó¦bSQL»yªk¤¤¤Þ¥ÎREPLACE ¨ú¥NÂù¤Þ¸¹©O¡H
¦p¦ó»PMYSQL¸ê®Æ®w¤¬°Ê©O¡H
¦¬ÂÃ
¤À¨É
dechiuan999
µoµu®ø®§
¥[¬°¦n¤Í
dechiuan999
·í«eÂ÷½u
UID
1016
©«¤l
231
¥DÃD
55
ºëµØ
0
¿n¤À
293
ª÷¿ú
293
ÂI¦W
0
§@·~¨t²Î
winxp
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
KEELUNG
¦b½u®É¶¡
41 ¤p®É
µù¥U®É¶¡
2010-7-24
³Ì«áµn¿ý
2018-8-28
¤¤¾Ç¥Í
©«¤l
231
¥DÃD
55
ºëµØ
0
¿n¤À
293
ÂI¦W
0
§@·~¨t²Î
winxp
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
KEELUNG
µù¥U®É¶¡
2010-7-24
³Ì«áµn¿ý
2018-8-28
2
#
µoªí©ó 2015-3-26 14:42
|
¥u¬Ý¸Ó§@ªÌ
ÁÂÁ¦U¦ì¤j¤j¡C
¤p§Ì¤v§ä¨ì¸ÑÄÀ¤è¦¡
»yªk¥[µù
.Bodypart.Charset = "Big5"
.HTMLBodypart.Charset = "Big5"
·P®¦¦U¦U¦ì¤j¤j¡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ªí
¤U¤@¥DÃD
¤W¤@¥DÃD
Excel£¸¯ë°Ï
EXCEL±MÄݰQ½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·