[AccessD] 2 email attachments

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Mon Dec 8 16:14:20 CST 2003


Hi 
May I make some (stupid) remarks, under the moto "You never know"?

1) Does the file exist?
2) What is dtEdate?
Depending on your country settings you can not use a date format for a
filename a "/" is forbidden in a filename.
Same thing if dtEdate contains time. A ":" is also forbidden.

Erwin



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Monday, December 08, 2003 7:27 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] 2 email attachments

So what's the error message that you get?

Lambert

> -----Original Message-----
> From:	Oleg_123 at xuppa.com [SMTP:Oleg_123 at xuppa.com]
> Sent:	Monday, December 08, 2003 1:11 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] 2 email attachments
> 
> heyyy,
> yeah the problem is with that line, if its not commented out I get an 
> error message. (i just commented it to meake sue there were no other
> problems) that functions sends several emails, but this one is the 
> only one thats supposed to have 2 attachments
> 
> 
> > Yes, I saw that, but I assumed that it was commented out as there 
> > was some problem with that line of code (what I could not image). 
> > But as you know, "assume" makes an ass out of U and me. <g>
> >
> > Lambert
> >
> >> -----Original Message-----
> >> From:	Elizabeth Carter [SMTP:Elizabeth.Carter at telus.com]
> >> Sent:	Monday, December 08, 2003 12:33 PM
> >> To:	Access Developers discussion and problem solving
> >> Subject:	RE: [AccessD] 2 email attachments
> >>
> >> The only thing that I see is that the second call to 
> >> attachments.add is commented out.
> >>
> >> Liz
> >>
> >> -----Original Message-----
> >> From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com]
> >> Sent: December 8, 2003 9:14 AM
> >> To: 'Access Developers discussion and problem solving'
> >> Subject: RE: [AccessD] 2 email attachments
> >>
> >>
> >> I don't see anything wrong with your example code. For each file 
> >> you need to attach you call the Mail Item's Add method, just as you

> >> indicate.
> >>
> >> Are you getting an error message? If so, what?
> >>
> >> Lambert
> >>
> >> > -----Original Message-----
> >> > From:	Oleg_123 at xuppa.com [SMTP:Oleg_123 at xuppa.com]
> >> > Sent:	Monday, December 08, 2003 12:04 PM
> >> > To:	accessd at databaseadvisors.com
> >> > Subject:	[AccessD] 2 email attachments
> >> >
> >> > Hey Group,
> >> > Daoes anyone know how to make 2 attachments on a single message ?
> >> >
> >> > Set objM = objO.CreateItem(olMailItem)
> >> >     With objM
> >> >     .To = "Michael at xx.com"
> >> >     .CC = "Rebecca at xx.com"
> >> >     .Subject = "HED " & dtSdate
> >> >     .Attachments.Add sJAdir & "HED" & dtEdate & "-Term" & ".xls"
> >> '.Attachments.Add sJAdir & "HED" & dtEdate & "-Hire" & ".xls"
> >> .Send
> >> >
> >> > End With
> >> > Set objM = Nothing
> >> >
> >> >
> >> > -----------------------------------------
> >> > Get Breaking News from CNN, ABC, NBC, CBS Now.
> >> > http://www.xuppa.com/news/?link=webmail
> >> >
> >> >
> >> > _______________________________________________
> >> > AccessD mailing list
> >> > AccessD at databaseadvisors.com
> >> > http://databaseadvisors.com/mailman/listinfo/accessd
> >> > Website: http://www.databaseadvisors.com
> >> _______________________________________________
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> >>
> >> _______________________________________________
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> 
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list