Email VBA script help

Hi,

I've tried adopting the script below to suit my needs, but it doesn't work. Basically I need to look up a name in column B, if it matches it will send the entire row (or number of rows if more than 1 match) to the email address in the worksheet "MailinfoA".

I have adapted this from a script which looks up column A, but I'm already using this script and need to run another looking at column B if this makes sense.

Please Login or Register  to view this content.

Can anyone help here, the script worked before I tried to amend.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time but you are not a new member so should know this rule. --6StringJazzer

Thanks

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

There are several conditions that could cause this code to do nothing. The quickest way to debug this is to see your data. Can you provide your Excel file with data? You can alter the email addresses and other private information, but the problem could be in your data just as easily as it could be in the code.

deleted post

Sorry, I do not trust that web site. Please attach your file directly in a post here.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Hi,

I have attached the file below, basically the 'Email Managers' link works fine, but the 'Email Regional Managers' doesn't do anything and I'm not sure why.

I want the Email Regional Managers macro to lookup the regional manager column in the populated tab and email those to the regional managers.

The ideally I would like to combine both these as one macro where firstly it looks up the Manager column and emails just those to the Managers, then looks up the Regional Managers column and emails just those to the Regional Managers.

Hope I've made sense, and thanks for your help!