|
Sub SendEmailByOutlook()0 I1 B3 Z- u4 z4 j, d" y! @
' K, ?5 C+ i4 ^1 s4 |3 F" @
On Error Resume Next0 }% m6 |- q( ^- S# U6 X1 t4 `) u7 ?
Dim rowCount%, endRowNo%* l: m- |; D3 }. f
Dim objOutlook As Object
( `. E% p, Z g- z3 A( j+ h' h! B Dim objMail As MailItem
& _, I9 L/ J) g; _6 |% p+ F1 M$ C v! _# l- K
'庢摼摉慜岺嶌昞梌Cells(1,1)憡楢揑悢悩嬫峴悢
; b3 M- ^# l$ f endRowNo = Cells(1, 1).CurrentRegion.Rows.count
# {4 D! V6 T; N) A6 Y" z- c1 s- ]7 |- \+ h& }5 b( E, H7 G3 V" [
'憂寶objOutlook堊Outlook墳梡掱彉懳徾1 J5 p6 b+ B6 X: g# R3 |+ A
Set objOutlook = New Outlook.Application
8 S7 m0 }6 ]- ], N* j5 M5 U" {# N; W4 ^) ]- C- A8 B* a
'奐巒弞娐敪憲揹巕儊乕儖丆樃戞擇峴奐巒丆戞堦峴惀僥乕儅9 C' [/ R" ]2 k$ n. y
For rowCount = 2 To endRowNo
/ X; H( X) e2 r9 M6 y Set Newbook = objMail.Attachments.Add
1 q. l! k+ m, V. v" R2 E4 L If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "仜" Then
P9 r+ }+ z, r9 X
N+ v5 ]4 x/ S0 V
- e) X& z+ E3 J '憂寶objMail堊堦槩儊乕儖懳徾7 W7 v' Z& H* M# F' ^( }. B
Set objMail = objOutlook.CreateItem(olMailItem)' p1 z8 e/ j* ?- r/ m
With objMail. B- i) B6 c, e5 H8 S
6 M' y3 J. Z# ?4 j
'愝抲澗審恖抧毈- c E/ Y$ i# E( O$ K" s: E
.To = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "e") '"fantasia@sina.com". _) D% C* O; G; D+ l
) ~7 t( `4 E) ~5 v
'愝抲儊乕儖僥乕儅; q1 B+ E* u# P( I
.Subject = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "傊偺媼梌柧嵶" '"儊乕儖僥乕儅"
* h0 q9 N* p8 c( n; Z3 K
4 @/ F3 Z4 I6 C '愝抲儊乕儖撪梕3 [7 R/ o4 o) v
.Body = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "條" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "j") & "寧偺媼梌柧嵶傪偛棗偔偩偝偄丅" '"儊乕儖撪梕"8 V; C, D/ h$ |& u
'敾抐惀斲愝抲僷僗儚乕僪
0 Y+ g) o0 o" D: b) @ If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h") <> "" Then3 [+ v1 X4 E& b' i* \* c2 L
6 Q E9 b0 [3 f; V7 q* J' d
Newbook = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h")
' ?5 l# G6 D& b/ G' p/ Q7 N/ c& f4 g# I$ ]! a
End If) l2 f$ S8 E7 x0 y
'愝抲晬審
2 \6 Z0 j& J+ p# B .Attachments.Add Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "g") '"c:\users.ctl"
9 h! x% N; q. `1 z- C% ~
( A! C$ u" M* z3 h .send
4 Z, C. t: W! V! n' r4 }! i
5 n8 L5 Z) d; K+ E4 a6 [7 l" K7 [& o MsgBox "暥審敪憲惉岟"+ V' W1 F, U5 d; c9 b
; S5 A$ P/ ]9 k* G' ?5 J
Attachment.SaveAsFile "D:\mail" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "d")
& ]% W J; `1 d) V* g5 m- z5 N0 N) b6 m, c u9 ]
End With/ ]! ]* I2 U" C. j% J6 A& c6 q
If Err.Number = 0 Then
6 k8 z4 K3 c `7 O Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "惉岟"
9 f% P$ E- x9 a, R2 ? Else
# N+ M) f$ a( v+ Z1 a6 { Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "幐攕"* h6 M# l& M( P" ^) r/ ]; z
End If
- ~1 q! ?& X( M2 u. P; \; b" a# k. K6 j. \, h+ Z
Application.DisplayAlerts = True
8 B9 m, K6 c# P1 s! c+ I Else$ d' p3 F# w/ w
Set objMail = Nothing
# [3 K0 ~: C" m0 O8 N% h3 L Next
* Z/ W2 ]6 @3 f$ y) A5 e 'objOutlook懳徾傪攑婞偡傞+ q2 z& s. h9 S; X4 ~! }5 {/ g
Set objOutlook = Nothing
( ?; i, L3 k2 o7 v) R& m3 R. I( ^ End If& A$ K [8 O) [: A' w2 u& q4 {
End Sub0 z# \( A. W" a S( ~
" Q( y) s* G5 b; C
0 ~/ E i8 \2 e4 \& u% {
|
|