Hi,
I realise there are already several threads on this, but I've read quite a few and I just can't seem to get it to work using any of the methods.
This is my code:
I keep getting the following error "Array lower bound must be zero".
Please Login or Register to view this content.
Does anyone have any idea of how to fix this?
Thanks!
Mike
Hi,
Which line is highlighted in yellow when you get the error message.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi man, thanks for the reply. The line that read "aEmail.to = strRecipients"
Hi
The variable strRecipients is returning a range value. In order to include a list of recipients in an Outlook email the recipients needs to be a text string of names separated by a ";" character.
The way I generally approach this is to use a loop to build the text string. e.g.
Dim stEmailNames As String
Then your Outlook To line isPlease Login or Register to view this content.
Please Login or Register to view this content.
Ah, awesome, that worked, thanks so much!
OK, glad to have helped.
Of course if the email names never change I'd be inclined to create the text string in an Excel cell and just read that cell in the .To instruction thus avoiding the loop altogether. I only generally use the looping approach where I have a selection criteria alongside the email table of names where only a subset of the names needs to be included. In that event I build the selection column into the loop and only add the name of it is 'ticked'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks