|
Sub SendEmailByOutlook()5 R9 b" g9 H+ m% s+ g+ c8 V
4 ]! u$ ~! G% c0 ` On Error Resume Next
3 ]8 c1 N$ U/ [9 ]. U4 C ^* d6 Y+ W Dim rowCount%, endRowNo%9 Y8 W+ T y, l: D* @2 e
Dim objOutlook As Object1 I6 u3 R U# L2 O n5 W
Dim objMail As MailItem' O( Z! }+ E; ]
# [% g* C5 m6 }% }- z9 S
'庢摼摉慜岺嶌昞梌Cells(1,1)憡楢揑悢悩嬫峴悢" ?2 ]( I0 p/ O4 D5 P) G. t) N5 Q
endRowNo = Cells(1, 1).CurrentRegion.Rows.count; t8 L$ C4 S" k" a# V" T
0 f0 x/ m# m2 r- ]8 R$ l# { '憂寶objOutlook堊Outlook墳梡掱彉懳徾- v0 H" s1 _8 F
Set objOutlook = New Outlook.Application
1 i/ b4 r( x5 e/ u: Z! s$ ?7 w9 V( y% H: c- N* o2 U+ g& k7 g' ~! P
'奐巒弞娐敪憲揹巕儊乕儖丆樃戞擇峴奐巒丆戞堦峴惀僥乕儅
! q) @3 @( {$ [/ M) H For rowCount = 2 To endRowNo' d$ x$ m: F7 S2 B
Set Newbook = objMail.Attachments.Add
5 X; f% ]/ V- N/ ^& ] If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "仜" Then
; {1 c* ^4 ~4 W$ ?7 p$ u
+ c2 P# o" F3 Z
4 \8 w7 v) ]( x6 V' S9 v8 [ '憂寶objMail堊堦槩儊乕儖懳徾
2 a; n# L9 L2 L4 W! t( F7 f' e Set objMail = objOutlook.CreateItem(olMailItem)5 `( u; l# Q" D4 a8 X4 d8 U8 x
With objMail
! b" N* W$ @* H! C# [& L4 k9 B6 m( o9 R' g( b u
'愝抲澗審恖抧毈, k; T) c' G" i& p: Q/ s2 v
.To = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "e") '"fantasia@sina.com"! ~% r& T7 j. w8 U' L1 u' y
- {! V* Q# T/ B; {; @2 `8 J& _9 Z
'愝抲儊乕儖僥乕儅
! O! b" s3 d! O9 v+ ? .Subject = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "傊偺媼梌柧嵶" '"儊乕儖僥乕儅"
/ F5 a/ u" k* I' c
: d4 q6 t( V' S: e' \$ i, g" H '愝抲儊乕儖撪梕( x5 U' F$ d* R, U* b E7 L
.Body = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "條" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "j") & "寧偺媼梌柧嵶傪偛棗偔偩偝偄丅" '"儊乕儖撪梕"" S& r6 H" ?" c5 P
'敾抐惀斲愝抲僷僗儚乕僪 H# j7 L# q7 V/ e0 ?. u6 }
If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h") <> "" Then" w9 y# Z% K: ]' b
' z- F& K3 W6 |( K Newbook = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h")
- Y" B$ M1 p) Z- Y6 {" G& G* J+ |# N) B( I5 y5 _
End If
8 d5 g9 ~1 v. N% O% H '愝抲晬審/ f" \+ [2 H8 t4 _. u3 V
.Attachments.Add Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "g") '"c:\users.ctl"- `* [6 a2 ?1 M
4 b: s; ~/ Q/ j. g' P .send
5 j& V9 q- A6 |
2 j* j1 Y* B2 z, X MsgBox "暥審敪憲惉岟"
( i; q0 I) V* u( y9 @, B
5 V7 F! V) P+ R If Err.Number = 0 Then
% o; ]! v; H! e# w; ` Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "惉岟"
& w. s* I1 S5 h) T' [- o Else n) d3 \, e9 {1 k
Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "幐攕"
" w2 K! ]& a) N. I* d; o9 V0 V/ d' Q End If( o a- @) A+ l7 a2 n
Attachment.SaveAsFile "D:\mail" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "d")* I# \9 I; a( X8 w# X4 S
End With
8 T- O9 a1 P8 E Application.DisplayAlerts = True5 y# L/ N# K8 Z- L, H
Else, e* u, ~' z c
Set objMail = Nothing# P; _/ N9 {4 P- Y3 \" [* i
Next' e* G2 T# \: ~! X( Y
'objOutlook懳徾傪攑婞偡傞$ i% D8 l3 a, W9 _6 z7 A
Set objOutlook = Nothing
$ A" N5 O" b( { h$ O End If
1 k/ ]* T( B9 v9 w1 \8 SEnd Sub
* L. r( `8 u% ?) E' L- z H7 A& w3 q8 }$ _
, `, h( P. L0 o, ]5 I; J
2 h. P+ ~' D; [/ i
0 n* P+ k+ n, o: P# k2 u. k: m8 t1 w, K( y1 m
9 n3 Q+ G, L- \( v) W m& G! _6 k: F8 q
" W% ^" [$ R% q8 g
7 l+ m# v. E3 H6 {9 z* e+ n5 }+ `8 f8 v; ]+ Z" p8 x' ?( F! r
|
|