Search results

Thanks for your detailed response. I will make these changes and let you know if it works. The path should be correct. The code that I started with, using that path worked perfectly. I didn't get the error until I started trying to make these changes to identify the "from" email. thanks!!!

When I take away the brackets i'm getting an error on that line that says I have the wrong number of arguements. Any other ideas?

Thank you for your help. I seem to be having a problem with this part: Send_Email (strDPath & strFName), "name@mydomain.com" Here's the full Name file and send Email code.

First, thanks again for your help. The code works great. However I have run into an issue. I'm developing this DB for another department that has multiple email addresses in the same MS Outlook. I need to make sure that these emails are sent from a specific email address. Is there a way to...

One more question. How would I make this DLookup statement pull multiple criteria and add a date to the naming convention? For example, I want my name to be Dlr_Code + Order_Number + current date instead of just dlr code. Thanks again!

Hey, it works! I had a typo in the report name. Thank you SO much for your help. You've helped me to look very impressive in my project meeting next week! I'll be sure to save this code and pass it on to someone else who may need it.

I made these changes, but am still getting the error on the DoCmd line. Still doesn't recognize the rpt. hmmm..

Ok, looks like I need a little help. When I try to run the code, using the RunCode action in a Macro, I get an error saying that it "cannot find the object 'rptRun_Notifications'". This is the exact name of my report, so I'm not sure what the problem is. Here is the first part of the code...

Yes it only returns one record. I'll try to get this to work and check back. thanks!

This looks like it does part of what I need, but I don't see where I can reference a query to find the email address, or how to reference the query to name the file. These are the parts that are really causing me problems. thanks again.

Thanks very much. I'll give it a try.

I can't be the only person who's tried to do this, can I?

BTW, if it maters, I will only be sending to one email address at a time.

Hello all, I'm in Access 2007 and stuck. I've been trying to do this with a macro, but I think I'll need some VBA to get all functionality. Unfortunately it’s been several years since I’ve written any code, and the knowledge seems to have left me. I’m hoping one of you has done this and...

I'm so glad I found this forum! I'm an accountant who is recently getting back into building DBs after being out of it for several years. I used to do some fairly complicated programing, but seem to have forgotten most of it, so i'm hoping to fill in the blanks here. thanks, Damian