Multiple Attachments on single email from continuous subform (1 Viewer)

[allen675]

Done, back to the original problem please see screenshot

 

[theDBguy]

Done, back to the original problem please see screenshot

Did you see my follow up post #20?

 

[allen675]

Getting the attached response. I will say that when I hover over & strPaths(x) It does now display one of the file names but WITHOUT the file extension?!

 

[allen675]

Did you see my follow up post #20?

No?

 

[theDBguy]

No?

But now you have, right? Please give it a try and let us know what happens.

Also, are you saying the result of

?SimpleCSV(strSQL)

in the Immediate Window was this?

SELECT [FileName] FROM ContactProofT WHERE CustomerID=4

If so, that doesn't sound right.

 

[allen675]

So done as per post #20 and result as per screenshot.

As per my last post if I hover over strPaths(x) it displays one of the file names without file extension. At this point how does the code know what directory to look in as we haven't defined it?

 

[theDBguy]

So done as per post #20 and result as per screenshot.

As per my last post if I hover over strPaths(x) it displays one of the file names without file extension. At this point how does the code know what directory to look in as we haven't defined it?

Hi. Thanks. Hmm, the result of your Immediate Window doesn't make sense. How about my request in Post #10? Are you able to post a sample db?

 

[allen675]

Okay so I figured it out. One of the file names had an "," between two words. I have removed this from the file and amended the stored file name in the table and he presto the code works, email template opens with all place holders present and attachments added

Thank you @theDBguy for all of your help.

Are you able to help me now handle some null values in this code please? Or should I start a new thread? I want to try and handle null values in both the place holders, notes and attachments.

 

[theDBguy]

Okay so I figured it out. One of the file names had an "," between two words. I have removed this from the file and amended the stored file name in the table and he presto the code works, email template opens with all place holders present and attachments added

Thank you @theDBguy for all of your help.

Are you able to help me now handle some null values in this code please? Or should I start a new thread? I want to try and handle null values in both the place holders, notes and attachments.

Glad to hear you got it sorted out. I also see you already started a new topic. Good luck with your project.