Using CDO and trying to add multiple attachments...

[n_s_simpson]

Hi guys

I've nearly finished the program I'm working on. However please can
someone please tell me how I add multiple file attachments if I'm using
the following code to send email:

With iMsg
Set .Configuration = iConf
..To = "(e-mail address removed)"
..CC = ""
..Bcc = ""
..From = """Nick Simpson"" <[email protected]>"
..Subject = "Whatever"
..TextBody = "The usual"
..AddAttachment "" <<< I ASSUME IT'S HERE THAT NEEDS
ALTERING
'.AddAttachment filetoopen(2)
..Send

 

[n_s_simpson]

Oh one other question...

Is it possible to add hypertext into the body field?

I want to say that if you need Adobe Reader please download from...

Thanks again

Nick

 

[n_s_simpson]

Can anyone help with this query or will I need to use a completely
different method to email as required?

If there is another method please can someone point me in the right
direction?

Thanks again

 

[n_s_simpson]

Ok people I've found out how to send links in the body:

TextBody = "http://www.whatever.com/file.zip"

So my only outstanding query is how to send multiple files in one email
using CDO.

I tried to repeat the .AddAttachment line but that doesn't work.

Any ideas?

Nick

 

[Ron de Bruin]

Repeat the line

.AddAttachment "C:\Data\file3.txt"
.AddAttachment "C:\Data\file1.txt"

 

[n_s_simpson]

Hi Ron

I am so annoyed with myself. I tried that first of all thinking it
would work and kept getting errors. It was late last night so was past
my best.

Just realised that I had an error in the path for the file!! That is so
frustrating but thanks for making me re-visit the same coding. It works
perfectly.

Nick

 

[n_s_simpson]

Hi people

My program seems to be working ok but one query is that when using CD
it seems to free up Excel before it's completely the subroutine.

This is a problem because I have a cancel button on my form which end
the program before it's sent the email.

Should it be doing this? I have got an idea of how to stop this issu
but want to make sure that it's supposed to do this first.

Thanks

Nic