VBA Send Email and Files to Recipients On List

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

Using a tutorial I've found here: http://www.rondebruin.nl/win/s1/outlook/amail6.htm I'm trying to put togther a script which runs through a list of potential email recipients and where the signal is set to "yes", attach two files and send an emal to the chosen recipient.

The format of the sheet is as follows:

Column B - Recipient Name
Column C- Recipients Email Address
Column B - Recipient Name
Column D - Send Email Signal
Columns E-F - Links to files to attach

The code below is the script which I've put together so far:

***UPDATED CODE***

Please Login or Register  to view this content.

I've tried to adapt the code at this point so that the range starts from row 4 until the last row:

Please Login or Register  to view this content.

I can recieve the email without a problerm, but the attachments are not attached to the email.

I just wondered whether someone could possibly look at this please and let me know where I'm going wrong.

Many thanks and kind regards

[Solus Rankin]

What are the value of these?

Please Login or Register  to view this content.

Are they complete paths? Can you attach your workbook as an example?

[hobbiton73]

Hi @Solus Rankin, thank you for taking the time to reply to my post.

I'm unable to post a worbook at the moment, but I can confirm that the values in column C is the mail address for the recipient and the values in columns E and F are the file paths to the files.

Having looked at this throughout the day, the main issue I have is that I'm unable to adapt the code so that the script starts looking for the values in columns E and F starting at row instead of row 1. I can sort the rest out.

I did try the obvious and change the reference of row 1 to row 4 and the relevant columns in the following section of code, but the email wasn't created, so I've clearly done something wrong.

Please Login or Register  to view this content.

Many thanks and kind regards

[Solus Rankin]

To really get a grasp on what you're trying to achieve it would be much easier with an example workbook.

[hobbiton73]

Hi @Solus Rankin, I just wanted to let you know that I've got this to work.

I'd realised that the columns which contain the file paths must be the actual file paths and not the 'Displayed Name'. I've now changed this and the macro works fine.

Many thanks for all your time and trouble.

All the best and kind regards