Francisco Tapia
my.lists at verizon.net
Thu Jul 3 13:12:49 CDT 2003
Messageyou could do that or you could learn to use Blat, which is an smtp
email command line client.
http://www.interlog.com/~tcharron/blat.html
you would need to become familiar w/ the syntax, but here is a solution I am
already using and it works... (see text attachment) please read through the
code to find the sections you need to modify. such as ip of your smtp
server, userid/pwd etc.
-Francisco
http://rcm.netfirms.com/
----- Original Message -----
From: Mike and Doris Manning
To: 'Access Developers discussion and problem solving'
Sent: Thursday, July 03, 2003 10:45 AM
Subject: RE: [AccessD] Send email with multiple attachments
Yup. Time to either join the Redemption bandwagon or use MAPI/CDO.
Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd
Sent: Thursday, July 03, 2003 11:48 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Send email with multiple attachments
I am using DoCmd.SendObject to email a report.
There is now a need to send 2 reports in the same email.
Is there code that will do this?
I'm guessing I need to use something other than DoCmd.SendObject.
TIA,
Mark Boyd
Sr. Systems Analyst
McBee Associates, Inc.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
begin 666 Blat.txt
M1G5N8W1I;VX at 4V5N9$)L871-86EL*'-T<D9R;VU.86UE($%S(%-T<FEN9RP@
M<W1R1G)O;2!!<R!3=')I;F<L('-T<E)E8VEP:65N="!!<R!687)I86YT+"!S
M=')3=6)J96-T($%S(%-T<FEN9RP@<W1R0F]D>2!!<R!3=')I;F<L($]P=&EO
M;F%L('-T<E-A=F5D1FEL94YA;64 at 07, at 5F%R:6%N="D-"B<M+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"B<@4')O8V5D=7)E
M(#H at 4V5N9$)L871-86EL#0HG($1A=&54:6UE(" Z(#(P,#(M,3(M,C<@,#@Z
M,C=A;0T*)R!!=71H;W(@(" @.B!&<F%N8VES8V\@2"!487!I80T*)R!687)I
M86)L97, at .B!S=')&<F]M3F%M92 H96UA:6P at 3F%M92DL('-T<D9R;VT@*&5M
M86EL(&%D9')E<W,I+"!S=')296-I<&EE;G0@*&QI<W0@;V8 at 861D<F5S<R!S
M97!A<F%T960 at 8GD@82!C;VUM82 B+"(I#0HG(" @(" @(" @(" @('-T<E-U
M8FIE8W0@*'-T<FEN9RDL('-T<D)O9'D@*'-T<FEN9RDL('-T<D%T=&%C:&UE
M;G0@*&9U;&P@<&%T:"!T;R!A='1A8VAM96YT<R!S97!A<F%T960 at 8GD@82!C
M;VUM82 B+"(I#0HG(%!U<G!O<V4@(" Z(%)E<&QA8V5M96YT('-E;F0 at 96UA
M:6P at 9G5N8W1I;VXL('1H:7, at 9G5N8W1I;VX@;6%K97, at 82!F=6QL(&-A;&P@
M=&\@=&AE($),050@=71I;&ET>2!W:&EC:"!I<R!A#0HG+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0HG#0I$:6T@<W1R4F5C
M:7!I96YT3&ES="!!<R!3=')I;F<L('-T<D%T=&%C:&UE;G1,:7-T($%S(%-T
M<FEN9RP@<W1R36%I;"!!<R!3=')I;F<L(&D at 07, at 26YT96=E<@T*#0H@(" @
M3VX at 17)R;W(@1V]4;R!396YD0FQA=$UA:6Q?17)R;W(-"@T*(" @($EF($ES
M07)R87DH<W1R4F5C:7!I96YT*2!4:&5N#0H@(" @(" @($9O<B!I(#T at 3$)O
M=6YD*'-T<E)E8VEP:65N="D at 5&\@54)O=6YD*'-T<E)E8VEP:65N="D-"B @
M(" @(" @(" @($EF($QE;BAS=')296-I<&EE;G1,:7-T*2 ](# @5&AE;@T*
M(" @(" @(" @(" @(" @('-T<E)E8VEP:65N=$QI<W0@/2 B+70@(B F($-H
M<B at S-"D@)B!S=')296-I<&EE;G0H:2D-"B @(" @(" @(" @($5L<V4-"B @
M(" @(" @(" @(" @("!S=')296-I<&EE;G1,:7-T(#T@<W1R4F5C:7!I96YT
M3&ES=" F("(@+" B("8@<W1R4F5C:7!I96YT*&DI#0H@(" @(" @(" @("!%
M;F0 at 268-"B @(" @(" @3F5X= T*(" @(" @("!S=')296-I<&EE;G1,:7-T
M(#T@<W1R4F5C:7!I96YT3&ES=" F($-H<B at S-"D-"B @("!%;'-E#0H@(" @
M(" @('-T<E)E8VEP:65N=$QI<W0@/2 B+70@(B F($-H<B at S-"D@)B!S=')2
M96-I<&EE;G0@)B!#:'(H,S0I#0H@(" @16YD($EF#0H-"B @("!)9B!.;W0@
M27--:7-S:6YG*'-T<E-A=F5D1FEL94YA;64I($%N9"!.;W0 at 27-%;7!T>2AS
M=')3879E9$9I;&5.86UE*2!4:&5N#0H@(" @(" @($EF($ES07)R87DH<W1R
M4V%V961&:6QE3F%M92D at 5&AE;@T*(" @(" @(" @(" @1F]R(&D@/2!,0F]U
M;F0H<W1R4V%V961&:6QE3F%M92D at 5&\@54)O=6YD*'-T<E-A=F5D1FEL94YA
M;64I#0H@(" @(" @(" @(" @(" @<W1R071T86-H;65N=$QI<W0@/2 B("UA
M='1A8V@@(B F($-H<B at S-"D@)B!S=')3879E9$9I;&5.86UE*&DI#0H@(" @
M(" @(" @("!.97AT#0H@(" @(" @(" @("!S=')!='1A8VAM96YT3&ES=" ]
M('-T<D%T=&%C:&UE;G1,:7-T("8 at 0VAR*#,T*0T*(" @(" @("!%;'-E#0H@
M(" @(" @(" @("!S=')!='1A8VAM96YT3&ES=" ]("(@+6%T=&%C:" B("8@
M0VAR*#,T*2 F('-T<E-A=F5D1FEL94YA;64@)B!#:'(H,S0I#0H@(" @(" @
M($5N9"!)9 at T*(" @($5N9"!)9 at T*(" @( T*#0H-"@T*<W1R36%I;" ]("(@
M(B F('-T<D%T=&%C:&UE;G1,:7-T#0IS=')-86EL(#T@(B M<W5B:F5C=" B
M("8 at 0VAR*#,T*2 F('-T<E-U8FIE8W0@)B!#:'(H,S0I#0IS=')-86EL(#T@
M<W1R36%I;" F("(@(B F('-T<E)E8VEP:65N=$QI<W0-"@T*<W1R36%I;" ]
M('-T<DUA:6P@)B B("UF("(@)B!#:'(H,S0I("8@<W1R1G)O;2 F($-H<B at S
M-"D-"G-T<DUA:6P@/2!S=')-86EL("8@(B M9G)O;2 B("8 at 0VAR*#,T*2 F
M('-T<D9R;VU.86UE("8 at 0VAR*#,T*0T*<W1R36%I;" ]('-T<DUA:6P@)B B
M("UO<F<@(B F($-H<B at S-"D@)B B0V]M<&%N>2=S($YA;64B("8 at 0VAR*#,T
M*0T*#0IS=')-86EL(#T@<W1R36%I;" F("(@+4AO<W1.86UE("(@)B!#:'(H
M,S0I("8@(DA/4U100R(@)B!#:'(H,S0I#0H-"B=S=')-86EL(#T@<W1R36%I
M;" F("(@+7@@(B F($-H<B at S-"D@)B B6"U)3D9/.B!4:&4 at 9F]L;&]W:6YG
M(&5M86EL(&ES('!R:79I;&%G960N($ET(&ES(&YO="!T;R!B92!C;W!I960@
M;W(@9F]R=V%R9&5D(&EN(&%N>2!W87D@=VET:"!O=70@<&5R;6ES<VEO;B!O
M9B!3;VUE($-O;7!A;GDN(B F($-H<B at S-"D-"@T*<W1R36%I;" ]('-T<DUA
M:6P@)B B("UX("(@)B!#:'(H,S0I("8@(E at M24Y&3SH@(B F($-H<B at S-"D-
M"G-T<DUA:6P@/2!S=')-86EL("8@(B M;F]H(@T*<W1R36%I;" ]('-T<DUA
M:6P@)B B("UN;V at R(@T*<W1R36%I;" ]('-T<DUA:6P@)B B("UL;V<@(B F
M($-H<B at S-"D@)B!#=7)R96YT4')O:F5C="Y0871H("8@(EQ";&%T3$]'+G1X
M="(@)B!#:'(H,S0I#0IS=')-86EL(#T@<W1R36%I;" F("(@+7-E<G9E<B B
M("8 at 0VAR*#,T*2 F(")93U5224Y415).04Q%34%)3"!)4"(@)B!#:'(H,S0I
M#0H-"G-T<DUA:6P@/2!S=')-86EL("8@(B M<&]R=" R-2(-"G-T<DUA:6P@
M/2!S=')-86EL("8@(B M=2!54T52240B#0IS=')-86EL(#T@<W1R36%I;" F
M("(@+7!W(%!!4U-73U)$(@T*<W1R36%I;" ]('-T<DUA:6P@)B B("UT<GD@
M,R(@)U1H:7,@;W!T:6]N('1E;&QS(&)L870@=&\@=')Y('1R>2!A9V%I;BXN
M+ at T*<W1R36%I;" ]('-T<DUA:6P@)B B("UD96)U9R(-"@T*)U-H96QL(%=A
M:70 at 1G)O;0T*)VAT=' Z+R]W=W<N;79P<RYO<F<O86-C97-S+V%P:2]A<&DP
M,# T+FAT;0T*4VAE;&Q786ET(")#.EQ0<F]G<F%M($9I;&5S7%EO=7)0<F]G
M<F%M)W, at 4&%T:%QB;&%T+F5X92 M("(@)B!S=')-86EL("8@(B M8F]D>2 B
M("8 at 0VAR*#,T*2 F('-T<D)O9'D@)B!#:'(H,S0I+"!V8DAI9&4-"@T*#0I$
M:6T@<W1R4F5S<&]N<V4 at 07, at 4W1R:6YG#0II(#T at 1G)E949I;&4-"@T*3W!E
M;B!#=7)R96YT4')O:F5C="Y0871H("8@(EQ";&%T3$]'+G1X="(@1F]R($EN
M<'5T($%S(&D-"E=H:6QE($YO="!%3T8H:2D-"B @("!);G!U=" C:2P@<W1R
M4F5S<&]N<V4-"B @("!)9B!);E-T<B at Q+"!S=')297-P;VYS92P@(E1H92!M
M86EL('-E<G9E<B(L('9B5&5X=$-O;7!A<F4I(#T@,2!/<B!?#0H@(" @(" @
M26Y3='(H,2P@<W1R4F5S<&]N<V4L(")(879E('EO=2(L('9B5&5X=$-O;7!A
M<F4I(#T@,2!4:&5N#0H@(" @(" @($1E8G5G+E!R:6YT('-T<E)E<W!O;G-E
M#0H@(" @(" @($US9T)O>"!S=')297-P;VYS92P@=F)/2T]N;'DL(")%;6%I
M;"!&86EL960A(@T*(" @($5N9"!)9 at T*5V5N9 T*#0I#;&]S92 C:0T*2VEL
M;"!#=7)R96YT4')O:F5C="Y0871H("8@(EQ"3$%43$]'+G1X="(-"@T*#0H-
M"@T*4V5N9$)L871-86EL7T5X:70Z#0H@(" @3VX at 17)R;W(@4F5S=6UE($YE
M>'0-"B @(" -"B @("!/;B!%<G)O<B!';U1O(# -"B @("!%>&ET($9U;F-T
M:6]N#0H-"E-E;F1";&%T36%I;%]%<G)O<CH-"B @("!396QE8W0 at 0V%S92!%
M<G(-"B @(" @(" @0V%S92!%;'-E#0H@(" @(" @(" @("!-<V=";W@@(D5R
M<F]R("(@)B!%<G(N3G5M8F5R("8@(B H(B F($5R<BY$97-C<FEP=&EO;B F
M("(I(&EN('!R;V-E9'5R92!396YD0FQA=$UA:6P@;V8 at 36]D=6QE($UO9$5M
M86EL7T)/5"(-"B @("!%;F0 at 4V5L96-T#0H@(" @4F5S=6UE(%-E;F1";&%T
E36%I;%]%>&ET#0H@(" @4F5S=6UE#0H-"D5N9"!&=6YC=&EO;@``
`
end