Urgent support needed. Multiple emails, multiple Excel workbooks, at once.

[DocAElstein]

Hi reda2006
Welcome to the excelfox Forum.

I have a good basic VBA Knowledge and automate a lot of my daily stuff with it.
But I have never sent an Email using VBA.
But I think I can manage a micro response for you:

Here’s my 'micro':
Do a simple Internet search with terms like
__ send email using vba
or better still
__ send email using vba youtube

You will see that you are flooded with a lot of tutorials showing you how to do it.
I just took a quick look and I think some of them are very easy to follow.
I like this guy, he is very slow and thorough
https://www.youtube.com/watch?v=pFl7W8d7d4M
But best is to go through a few of the vidios.
What I would ( will probably later**** ) do is download them all, make a play list and let it run in the background for a few days while I do something else ..

They will tell you how to send a single email I expect. I think I noticed some showing how to add an attachment as well.
It is very simple basic VBA stuff to automate something to be done a lot of times once you have figured out how to do it for the single case.
It is also very simple VBA stuff to read the email addresses and the file names from the lists as you described them
You will need to know a bit of basic VBA stuff, but you really should do that even if you are doing it as a one off.
If you do anything at all with Excel then you will find that some things are incredibly easier with a bit of simple coding.
Most Excel stuff itself is just a lot VBA coding already written. So VBA is crying out to be used to tailor things more exactly and efficiently to your requirements.

So the best thing to do is to:
_ get a bit clued up on how to do it.
_ while you are doing that , make up a mock up file / files with desensitised dummy data. Keep the data to a minimum but pick it carefully to test out all scenarios.


Try and get that working. Usually a code working on a small amount of data will work on a much larger amount with little or no modification
_..____________

So, there you go - That was a fairly micro response, at least very micro by my standards.

****Having said that I might be interested in trying to automate sending some files by E-Mail myself sometime in the next week or so. Let us know how you get on and might be able to help later.
But if it is urgent, then as snb suggested, a Forum probably isn’t the best place to ask. A Forum is more of a “self help group” really. We all have a lot of other stuff to do, and rarely anyone responds to an “Urgent” appeal here.
Anyway I will take a look at this in few days for my own case, so might post back , and will certainly take a look to see if you have posted anything
Good luck

Alan

_._____

EDIT: If you look at the bottom of this Thread you will often see suggestions for similar Threads:
VBASendEMailThreadSuggestions.JPG : https://imgur.com/qt1x7Mf
VBASendEMailThreadSuggestions.JPG
VBASendEMailThreadSuggestions2.JPG : https://imgur.com/X5zLEox
VBASendEMailThreadSuggestions2.jpg

It might be worth taking a look at those as well




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA