LinkBack URL
About LinkBacks
Hi all,
I have the following VBA Code and an Excel file from which the VBA get his data (25 lines).
My Problem is, that I do not have an attachment for every line. In this case the VBA will not finish.
Please Login or Register to view this content.
Hi all,
I have the following VBA Code and an Excel file from which the VBA get his data (25 lines).
My Problem is, that I do not have an attachment for every line. In this case the VBA will not finish.
Please Login or Register to view this content.
Last edited by torti111; 04-28-2016 at 03:05 AM.
Try this:
Please Login or Register to view this content.
Hi Rorya,
thank you for your help.
But there is a Problem with the following part: .Attachments.Add ActiveSheet.Cells(lngZaehler, 8).Value2
What is the problem specifically?
I have found, that the VBA works if I delete the path for the file that not exists. Perfect!
Do you have an idea if I have for two lines sometimes two files to attach?
Are the two attachments listed in the same cell? If so, how are they separated? If not, where are they?
how is the format to list them in the same cell? This is the first attachment in cell H3 = G:\Shareplan\test_31686\Plan\08\Sale Proceeds\sales_breakdown 210416 ret.pdf and the second file Name is sales breakdown 100516 ret.pdf
If you separate them with a comma, like:
G:\Shareplan\test_31686\Plan\08\Sale Proceeds\sales_breakdown 210416 ret.pdf, G:\Shareplan\test_31686\Plan\08\Sale Proceeds\sales breakdown 100516 ret.pdf
then you can use:
which will check each file to see if it exists and add it to the email if it does.Please Login or Register to view this content.
Hi Rorya,
thanks a lot.
But I have 24 different lines (for each City I have one line because in this line are different E-Mail addresses and subjects). Most of the cities have one attachment. 2 or 3 no attachment but not always the same and two of them have two attachments. The path is from h2 to h25.
Do you have a solution for this?
torti111,
there are two problems with this thread:
1. Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
2. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ben Van Johnson
Hi Ben,
I have changed the two Points.
Kind regards,
Thorsten
Sorry, but I fail to see how "the following code works not fine" is any more descriptive of your problem than "problem with code" is?
Your thread title needs to be something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
When you've done that, please clarify what the problem is with the last code.
I have 24 different lines (for each City I have one line because in this line are different E-Mail addresses and subjects). Most of the cities have one attachment. 2 or 3 no attachment but not always the same and two of them have two attachments. The path is from h2 to h25.
If I use a comma between the file path for each of them I get the following error message: Run-time error 52 - Bad file Name or numer.
The code works for every line with 1 attachment fine. If I have a second attachment I got this error.
Please give an exact example of the contents when there are two files.
Hi,
for two cities I have in a Special path sometimes two files which have to be attached:
for example: G:\Sale Proceeds\sales_breakdown 210416 bah br.pdf and G:\Sale Proceeds\sales_breakdown 210416 bah tr.pdf
Those are not separated by a comma.
If I make it in this way: "G:\Sale Proceeds\sales_breakdown 210416 bah br.pdf,G:\Sale Proceeds\sales_breakdown 210416 bah tr.pdf"
I get an error message: Run-time error 52 - Bad file Name or number.
I take it you don't actually have the " in the cell?
Which line gives the error?
Hi Rorya,
I don't have the " in the cell.
I have copied the code into a new file and now it works.
I have added: ".Save and .Close olPromtForSave "and now I have all E-Mails in my drafts - perfect.
Now the code drafts an E-Mail for every line. Is it easy to Change the code, that he don't create an E-Mail if there is no file to attach?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks