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 = "
..CC = ""
..Bcc = ""
..From = """Nick Simpson"" "
..Subject = "Whatever"
..TextBody = "The usual"
..AddAttachment "" <<< I ASSUME IT'S HERE THAT NEEDS
ALTERING
'.AddAttachment filetoopen(2)
..Send


--
n_s_simpson
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563

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
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563

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
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563

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


--
n_s_simpson
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563

Repeat the line

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"n_s_simpson" wrote in message
...

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


--
n_s_simpson
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563

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
------------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...o&userid=31859
View this thread: http://www.excelforum.com/showthread...hreadid=517563