In the VB below I can not seem to add a line that will send an attachment only if cell D2 is marked with an "x". I think a statement needs to be in the section in bold but I am not sure the correct syntax. Thank you.
VB
Please Login or Register to view this content.
If c.Offset(, 3) = "x" Then
This should test if column D has an "x" but it is case sensitive. If column D has a capital X, it's not a match.
This should be case insensitive.
If LCase(c.Offset(, 3)) = "x" Then
Otherwise, I don't see a problem with your syntax.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I made the change, however the email only sends now when D2 is marked with an "x". If C2 is marked with an "x" the email still needs to get sent just with no attachment. Thank you
Originally Posted by cmccabe
I made the change, however the email only sends now when D2 is marked with an "x". If C2 is marked with an "x" the email still needs to get sent just with no attachment. Thank youPlease Login or Register to view this content.
Last edited by AlphaFrog; 10-21-2015 at 12:05 PM.
That works great, last question if C2 is marked with an "x" is it possible to not have the attachment file opened at all? Thank you
You don't need to open the attachment file regardless if you attach it to the email or not. So just keep it closed unless you need to change something in the file.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks