email vba

im using this code but its sending sheet1 twice not sheet1 and sheet2

see att

Hi, laduk,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

Hi, laduk,

because you choose to have a code for each sheet invdividually and did not take care to refer to each sheet when getting any cellīs information. If you do not use the correct syntax the data will be taken from the active sheet (and not the desired one).

Iīd have a go with this (untested as no Outlook available for me for the time being):

Please Login or Register  to view this content.

Ciao,
Holger

great thanks but would like sheet2 to send a different messae ie number 2 message

cheers

Hi, laduk,

if you use a diffferent sheet for the address I would place the contents of the body on that sheet as well and refer to the areas.

Besides I would use the Autofilter to spot empty cells in Column E and work with a For Each on thise cells if available instead of looping through the whole ranges. It might not be a time factor here with just one set of data but imagine to have a thousand sets with just 20 which need to be send.

Ciao,
Holger