I need a vba that sends a multiple different range to a different recipient for each range.
For example, I have a range in A1-F30, with an email address and subject in H14:H15.
Then a different range in A32:F62, with a different email address and subject in H45:H46
And so on with possibly 100 different ranges and email addresses.
Is there a vba that will send a different email to all of those email addresses, with the range in the body of the email?
Last edited by gillyr7; 01-03-2014 at 11:47 AM.
I don't see a pattern to the ranges you want to send. How are they determined?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Basically 30 rows, skip a row, 30 rows, skip a row...
A1:F30 Range 1
A32:F62 Range 2
A64:F94 Range 3
A96:F126 Range 4
... (Possible >100 Ranges)
The H range can go anywhere to the right of each range. That does not matter. Whatever is easiest I guess.
Okay. If you place the required email address in the first row of the range it might be easier.
Can you attach a workbook with an example of how your data is laid out?
Hi,
I'm assuming the 2nd, 3rd & subsequent ranges were typos since they are all 31 rows.
So if you mean A1:F30, A32:F61, A63:F90 etc. and with the email address for each range in H1, H32, H63 etc. then this is an example of code I am using in several workbooks - adapted for your ranges
Please Login or Register to view this content.
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.
Test Sample.xlsx
A small sample is attached. Notice how a range might not have 30 rows total. The following range would still act as if the previous range contained all 30 rows.
The email that ends up going out can send all 30 rows no matter what, but it would be nice to only send rows with data in them. Not necessary though.
Richard, that is exactly what I need. Thank you. Is there a way to send each range as an attachment, instead of in the body of the email?
Hi,
Your original post specifically asked for the range to be included in the body of the email, and in addition you specifically said that all ranges were the same size, which is why I sent you what I did. Now seemingly as well as an attachment being required, the ranges are not the same size either.
When seeking help it's important that you are quite clear what you really want otherwise we all waste our time.
Are you now asking if you can generate an Outlook email with an attachment. If so then each range will have to be copied to a new workbook, saved as a file and then attached. Is this additional complexity what you really want?
Last edited by Richard Buttrey; 01-03-2014 at 11:44 AM.
I needed the range in each email per my original post.
I will mark this as answered as what you provided was perfect.
However, there is a future project that I will want the attachments included instead of the range in the body. I will open a new thread for that with a link back to this one. Feel free to answer that one, but thank you for your help so far.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks