UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Split Function This There Away To Find The Number Of Splits?, Access 2016    
 
   
InfoHound
post Nov 16 2019, 02:33 PM
Post#1



Posts: 1,175
Joined: 1-December 12



I'm using a variant (varFilePaths) to store the file paths of files a user selects from a file picker.
I want to attach each file to an Outlook email. If I can tell how many files are contained in the string varFilePaths then I could use a for next statement to attach each file to the email. Is there a way to do this?

Thanks

Go to the top of the page
 
theDBguy
post Nov 16 2019, 03:31 PM
Post#2


UA Moderator
Posts: 76,893
Joined: 19-June 07
From: SunnySandyEggo


Hi about?

NoOfFiles = Ubound(SplitArrayName)-1

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
MadPiet
post Nov 16 2019, 03:36 PM
Post#3



Posts: 3,367
Joined: 27-February 09



For a = LBound(arrayX()) to UBound(ArrayX())
olkMsg.Attachments.Add(arrayX(a))
Next a
Go to the top of the page
 
InfoHound
post Nov 17 2019, 05:27 AM
Post#4



Posts: 1,175
Joined: 1-December 12



Thanks guys those ideas worked perfect!
Go to the top of the page
 
theDBguy
post Nov 17 2019, 08:41 AM
Post#5


UA Moderator
Posts: 76,893
Joined: 19-June 07
From: SunnySandyEggo


You're welcome. Good luck with your project.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th December 2019 - 11:35 PM