By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

email including attachement

P: 72
I have a table like this:

Client ContactName Email
ABC ABC Name ABC@yahoo.com
CDC CDC Name CDC@yahoo.com
MNB MNB Name MNB Name

I am trying to send an email and attach a card (jpg file) to the above clients using the email address in the email field.
maybe creating a button in a form and when clicked the emails are sent.

Thanks
Dec 13 '07 #1
Share this Question
Share on Google+
2 Replies


Jim Doherty
Expert 100+
P: 897
I have a table like this:

Client ContactName Email
ABC ABC Name ABC@yahoo.com
CDC CDC Name CDC@yahoo.com
MNB MNB Name MNB Name

I am trying to send an email and attach a card (jpg file) to the above clients using the email address in the email field.
maybe creating a button in a form and when clicked the emails are sent.

Thanks
Two methods for your consideration

1) You will need an extra field in that table to identify the full path to the JPG file for each specific client record and then pass this full filepath path together with your other fields to an 'automation' routine that attachs the file to the mail message and sends it

2) If you think clever on your naming convention for the jpg file ie: ABC.jpg or CDC.jpg or MNB.jpg the logic then is If you store these files in a folder you can then merely target the folder and tell the automation routine to grab the filename of any jpg file that corresponds with the client name and attach it that way. This second method saves you having to manually input anything into the table because the logical link is on the filename portion of the JPG and the Client records identified by the first field you gave there.

If you are using outlook look at this MS link to give you an idea

http://support.microsoft.com/kb/161088

Jim :)
Dec 13 '07 #2

P: 72
thank you very much.
Dec 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.