-
Hi gmayor, your first suggestion is what did the trick with just one substitute of semi-colons in place of commas so that Outlook would recognize the string of addresses:
strTo = ActiveCell.Offset(0, -29).value & "; " & ActiveCell.Offset(0, -28).value & "; " & ActiveCell.Offset(0, -27).value
strCc = ""
strBcc = ""
Thank you very much gmayor for your help! I really appreciate it
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules