Please help me edit my VBA code/formula

[Jyggalag]

Hi all,

I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails):

Now I want to edit this file so I can target a list of emails in the emails, BCC and files to send columns from another sheet. If I want to make this edit (let's for simplicity's sake say that I keep my macro in Sheet 1, but move column O (emails), column P (BCC), and column Q (Files to send) to a new sheet I call Sheet 2). How would I need to change my code?

I would greatly appreciate some assistance here!

Thank you all

Kind regards,
Jyggalag

 

[Jyggalag]

Hi all,

I also have a similar issue, albeit a bit different, would appreciate assistance to this as well!

Link: Edit email macro to ignore certain emails

 

[johnnyL]

Try putting Sheets("Sheet2"). in front of your 'Cells(' in the for next loops that you have.

Example: Cells(i,15) would become Sheets("Sheet2").Cells(i,15)

Do the same for the Cells(i,16) & the Cells(i,17)

 

[Jyggalag]

Try putting Sheets("Sheet2"). in front of your 'Cells(' in the for next loops that you have.

Example: Cells(i,15) would become Sheets("Sheet2").Cells(i,15)

Do the same for the Cells(i,16) & the Cells(i,17)

Amazing! It worked!!

And very simple and easy-to-understand solution

Much appreciate JohnnyL!! Thank you so much :D

Kind regards,
Jyggalag

 

[johnnyL]

Glad to help @Jyggalag.