dazzerwrestle
New Member
- Joined
- Jul 26, 2007
- Messages
- 3
Hi I am new to this so I hope it makes sense & someone can help I am trying to send Individual rows of data from a workbook to different E-mail addresses without send the whole worksheet I have the code below which sends a complete workbook but only want to send say row 1 to joe Bloggs line 2 to say Fred Perry & so on.
I have a feeling that I may need to write an IF ELSE statement but am unsure.
ActiveWorkbook.SendMail Recipients:=" Joe Bloggs "
Any Help will be greatly Appreciated.
I have a feeling that I may need to write an IF ELSE statement but am unsure.
ActiveWorkbook.SendMail Recipients:=" Joe Bloggs "
Any Help will be greatly Appreciated.