|
Sub SendEmailByOutlook()
- L( j. g* ], X. H9 A; t1 M% ^8 G U4 ]9 f1 l# q: D3 @
On Error Resume Next
/ D4 J$ f- I4 M Dim rowCount%, endRowNo%
$ b" j/ f; q% ]2 { Dim objOutlook As Object+ F) G2 l! V, c4 j5 J# W0 e* J
Dim objMail As MailItem
, a# U/ R/ S& v
6 y W" L: y# K/ Z0 x* B2 Y '庢摼摉慜岺嶌昞梌Cells(1,1)憡楢揑悢悩嬫峴悢
( ^# s$ H6 t1 B2 }& \8 m endRowNo = Cells(1, 1).CurrentRegion.Rows.count% @- Y: q4 ~2 C0 y: `! k$ j
; f4 B8 e) {( n4 i1 P: W6 X6 v '憂寶objOutlook堊Outlook墳梡掱彉懳徾' Z" r \8 Q/ B
Set objOutlook = New Outlook.Application0 i8 a3 c$ Y0 U2 K m9 R
/ ^. Z$ |6 W. f( L3 ` '奐巒弞娐敪憲揹巕儊乕儖丆樃戞擇峴奐巒丆戞堦峴惀僥乕儅
H+ g8 R% X$ j3 k: o A t For rowCount = 2 To endRowNo) y, w% ?( G8 A, p4 u; o! G/ [$ R% ?
Set Newbook = objMail.Attachments.Add
' B: {( g: ]7 @+ M If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "仜" Then" `& Q; X2 h/ n7 n' h8 \0 r+ d5 i
* y6 k# s6 j+ b) l( V$ S0 Z
* j! ?4 v9 E# |" c7 M
'憂寶objMail堊堦槩儊乕儖懳徾
' X+ e6 f9 e0 V Set objMail = objOutlook.CreateItem(olMailItem)6 ~5 v. U; \; H+ ?: B
With objMail+ M) A, ` Y2 C3 ^- z+ A. u7 g6 t
6 k. a) D" [; d8 k" m h
'愝抲澗審恖抧毈! W1 m% D9 _* P7 ?5 |3 U3 |
.To = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "e") '"fantasia@sina.com"7 a3 g$ F% z3 S8 Y; _8 T# D
! O B5 I3 Q6 Y( a. o$ m/ c/ j Z Q7 R; g '愝抲儊乕儖僥乕儅
& l/ s, a- {. }/ I! D/ ]+ Z .Subject = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "傊偺媼梌柧嵶" '"儊乕儖僥乕儅"
- X: N" _0 Y7 v0 ]$ P" i1 \- r+ H) s3 G; J9 U1 Z; z
'愝抲儊乕儖撪梕
7 S: D: @; ^5 \; l .Body = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "i") & "條" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "j") & "寧偺媼梌柧嵶傪偛棗偔偩偝偄丅" '"儊乕儖撪梕"; |3 G M5 w, B: T S: H3 O
'敾抐惀斲愝抲僷僗儚乕僪
7 A6 I4 [* W$ E" T) j. M If Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h") <> "" Then
$ I) |( u" k& B1 k D
% L9 C! i9 j& v5 _ ^" d Newbook = Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "h")0 s. o j6 L1 w7 ~+ r8 t2 G
. D. w+ |" g! M1 M( A7 G
End If: I" j% f8 x- p$ @( \+ u/ h& j
'愝抲晬審
% Z# f3 Z+ ~' Q .Attachments.Add Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "g") '"c:\users.ctl"
; \/ Q- s% c' n7 `6 C
4 a6 g& A J! t/ v: d9 u: i/ ?; J .send
( o5 o& X2 D# `/ `8 \, e9 q( H9 x! S1 b- T4 j
MsgBox "暥審敪憲惉岟"0 B& j3 \' k! a8 a
, }+ P, y% l2 {- u! a' d( U Attachment.SaveAsFile "D:\mail" & Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "d")) y& Z- _! n8 v0 h: N: _( F! n
( L; U/ _. E6 k6 J: A* @3 a) J8 J End With5 b% l0 p1 X) ?* m u" L% I
If Err.Number = 0 Then8 z' O5 a& v. d6 o) R- e: ?
Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "惉岟"7 g6 r3 c o# _6 @5 Q
Else
! j; I; i4 S7 \8 f/ F) C Worksheets("憲怣埗柤堦棗媦傃抲姺暥帤").Cells(rowCount, "a") = "幐攕"
- h# q/ N9 t, l, V6 m' t, W/ W End If6 @) K, E$ _( O \: r9 L2 {
2 o7 G+ X) [; Q/ p5 c( t x
Application.DisplayAlerts = True
8 B* C3 U$ k: {1 a Else
6 Z2 a. {; |. e+ p' W$ c Set objMail = Nothing4 S; n' b5 z' O- S, d
Next# v* d$ P, C9 k* F
'objOutlook懳徾傪攑婞偡傞2 r8 S! E, L7 T R7 _
Set objOutlook = Nothing
1 R& `, W3 M: Q8 f End If, v8 }/ |5 P+ c! f
End Sub
C3 I. t0 s, S$ T1 t' E
_. {( @8 ]2 @: |5 E% E& O, U0 J+ g4 J) W1 n! Q" Z7 z" A
|
|