i want to send multiple emails using excel vba, i have a code but it sbneds only first mail, please help me.
Please Login or Register to view this content.
i want to send multiple emails using excel vba, i have a code but it sbneds only first mail, please help me.
Please Login or Register to view this content.
Hi ASNAEEM
Welcome to the Forum. Something like this:
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
What's in A1000?Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Daer Actually i have a sheet with
A = email ID
B = CC mail ID
C = Attachement path
D = Subject
E to H = Mail Message.
i want to send them all email using only single click.
A1000 is nothing just a assume that maximum will be 1000.
please help me in this regard.
If A1000 is empty, that's the reason it only sends one email.
Using sintek's code:
Please Login or Register to view this content.
Not still working now error is outlook does not recognized one or more names.
Are you getting an email displayed for each row? Does it contain the value in column A as the email address? If it is doing that, the code is working as it should. You need to check the format of your email addresses.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks