I have been trying to send a series of email using the mail merge so
that associated attachments are sent with each email - different for
each email address.

I am aware that there is a piece of code that is meant to sort this out
for me, I have tried using it and it doesn't seem to be working as it
should. I set up a test spreadsheet with 10 cells with my email address
in and 10 cells with different files paths in the next column. I
followed all of the directions for the VBA Code and eventually got to a
stage where i was prompted for the subject for the email and then it
continued to - what I thought was send the emails.

I was sat there for a few minutes clicking yes to all of the messages,
I know there is a program for this but I can not DL at work. After
clicking well over 30 times I tried to stop, ended up ending the task
through the task list. Why do i have to click over 30 times when I am
only sending 10 emails? And why after clicking over 30 times did I not
recieve a single email?

Can anyone help me on this issue?

TIA




--
Back2Basics