Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.
scottwallace, this takes a bit of VBA code and a free program called ClickYes like this http://www.contextmagic.com/express-clickyes/
otherwise you would have to click yes to the Security question for all 2500 emails.
Next are the photos in Access or are their Paths in Access?
scott, yes the Clickyes program should work with your Outlook.
I have some VBA code that will put all of the Photo Paths in to Access for you, as well as the code to email the Customers.
I can supply it if you give me the Name of the Table and Field it needs to go in.
That would be fantastic. I can't express my gratitude. I think I only need 2 fields. ImageName and EMail. Unless there is a way to insert the FirstName and LastName in there somewhere.
just in the table. They are not really needed. I thought it would be a nice personal touch if we could include their name in the salutation or something. It's not critical. The image name will be something like C:\IMTS\Img0068.jpg. Thanks.
Scott, here is the database and an Excel Spreadsheet showing the VBA References you may need to set, you will certainly need to set a Reference to Microsoft Outlook 10 Object Library. Yours may not be Outlook 10 but some other number depending on which version of Office you are using.
You will not need the Kodak ones though unless you use Kodak for your Photos.
Let me know when you have unzipped it and had a little play around with it.
How do I get those pictures if I failed to make it to the other booth to leave my card? Myself and 4 others at my company would like to see and download these pics of us next to the f-35 model. Please help!
OBP,
You are so the man! I tested the dB with some sample data and it worked great. I'm still playing with it but it looks like you are going to make me look like a hero. Splendid. Simply splended!
OBP,
I have a new problem. I had to move everything to a different PC for mailing. It has Access 2007 on it. Now the database doesn't work. I get this error when I select the file type.
Scott, it may simply be the case that you need to reset the VBA Library References to update them to Access 2007.
Or it may be that Access 2007 won't support the VBA code at all.
I know what it is. According to Microsoft it's because “The File Search task pane and the FileSearch object have been removed from the 2007 Microsoft Office programs”. I moved everything to my PC that has 2003 and it should be OK now. I will let you know. I'm going to leave this unsolved until I make sure it works again. Thanks.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!