Hi guys!
Is it possible to loop one single cell, lets say T1, in order to give it different values? For example: T1=1, loop, T1=2, loop, T1=3, loop
I tried to do it like this:
I want the loop to first define T1 as 1 then the following macro can take place:
Please Login or Register to view this content.
Then loop to T1=2Please Login or Register to view this content.
Thanks in advance!
You would use Range, if you know the letter ,
For I = 1 to 6
Range("T" & I).value
Maybe this would work :
Please Login or Register to view this content.
You can't do it that way... it would be:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
It doesn't work! It says compile error: next without for.. Can you see what is going wrong?
Please Login or Register to view this content.
Next i should come after End With...:
Please Login or Register to view this content.
But there is another issue here I think... each i will create a new outlook application instance, and sh did not exist in the macro so I have added it. Try this (changes in red):
Please Login or Register to view this content.
Last edited by Arkadi; 02-22-2017 at 12:59 PM.
Thanks Arkadi! That kind of worked, however the next problem it states is that the item has been moved or deleted and it references to the "to" part, which the attachment will be sent to by Outlook.
Please Login or Register to view this content.
Are you able to provide a workbook with sample data? Is it possible that the value in T24 is not the location (full path and filename) of the attachment?
Ik zie dat het "savepath" in T18 staat, en "saveas" in T19... wat staat er in T24? een combinatie van die twee?
Last edited by Arkadi; 02-24-2017 at 09:33 AM.
This is the worksheet! T24 is the precise name of the document. I read somewhere online that it could be due to the fact that the PDF and Email are both made in a different loop, which could give trouble. Do you have any experience with this or do you think it is something else?
Excel sheet.png
Hi again.... I see t24 has a filename... But isnt t25 the cell with the complete filename including c:\.........\xxx.pdf?
But yes.... They should be in same loop... The way it is now all emails would have last pdf as attachment.
Im on my phone.... When i get to a computer (2 hrs) i will look further.
You are right, I added a line so it should be T25. But that does not solve the problem. It sends the attachment and e-mail to i=1 but not to i=2,3,4,5,6, etc.
So it only sends the first e-mail..
Thanks Arkadi! Btw are you Dutch?
Hi Jstns,
Yes I'm Dutch, though I left when I was very young. (But will ALWAYS cheer for Oranje!)
As for the code, try this.... Note I created the outlook instance before the loop, since you don't need to open it every time. I also put a few notes because I think your subject and body rows are mistaken? Also.... I see you are changing T1 every time, does that mean the cell T8 has a formula so that the email address changes each time? Just curious.
Please Login or Register to view this content.
Last edited by Arkadi; 02-24-2017 at 09:41 AM.
Thanks Arkadi! It worked! You are a lifesaver. How can I set a print area within the macro?
My pleasure
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks