Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicate Email Addresses
I have a workbook that needs to get sent out to several different recipients.
Occasionally some of those recipients might be duplicates. How can I make sure that duplicate recipients receive only one copy of the workbook? What I've done to read the list of email recipients is use a for-next loop. Something like this: For a = 1 to 7 email(a) = Cells(a, 2) 'assuming the list is in column B next a Then I use another for-next loop to email the workbook. I'll bet there's probably a better way of doing this. Any help would be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Need help finding non-duplicate email addresses... | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) |