PLEASE HELP: Automatic mail merge to email

[adambedford]

How do I activate a word mail merge document in VBA and email it to the correct address.

I need to be able to click "confirm" and have it send a confirmation email to the client automatically. I already have the mail merge document, which is based on a query.

Any help would be greatly appreciated!

Adam

 

[ajetrumpet]

look through the SAMPLE DATABASES section. i have samples there that may help you.

 

[adambedford]

I had a look at the sample database but I couldn't figure out how the mail merge document is emailed to the recipient.

Any thoughts? Or have I completely missed that in the example?!

 

[wiklendt]

well, there's not much we can do if we don't know:

1) which example you've used
2) what your current setup is
3) what your current setup is doing
4) what you want your setup TO DO
5) what you've tried so far to get it working
6) any code that you've identified to be the problem

edit: there's MORE than enough information in this forum to get you started - just use the search tool (which is located at the top of EVERY page)

 

[ajetrumpet]

I had a look at the sample database but I couldn't figure out how the mail merge document is emailed to the recipient.

Any thoughts? Or have I completely missed that in the example?!

did you look at this or this? I would think a combination of the two would get you on the right track!

 

[adambedford]

Hi,
Yeah I had a look at them both, and I'm still not 100% how to do it. I have created a mail merge document but I dont get the option to email it. Could this simply be because I dont have an email client that is deemed suitable for the job? I'm using Windows Live Mail but dont have Outlook installed. Could this be it?

Thanks

 

[ajetrumpet]

isn't windows live mail on the internet? if it is, you can't use it. you have to have a default client set up on your machine! you can't automate emails through access with internet accounts. it's too complicated, and not worth it. yes, that could be it. i cannot give you a sample either, as I am in the hospital right now. if this thread still exists when i'm out, i'll try to build you one and show you how...

 

[adambedford]

Hi,

I still havent had much luck with this...
I tried ajetrumpets example, but I think I must have gone wrong somewhere becuase one time it didn't do anything and the second time it made Access crash.

I currently have a bookings table and a customers table and a query that combines field from each of these, along with a couple of calculations fields. The customers field stores name, address etc along with an email address.

I also have a "New Bookings" form that allows the user to enter booking information for a specified client.
Essentially what I'm hoping to achieve is that when the user clicks "Confirm" on the new bookings form, an email is automatically sent to the client (at the specified email address). The email will contain fields such as first name, last name, the property they booked, the total amount payable, the amount needed as a deposit and a date when the remaining balance needs to be paid by.

By default I use Windows Live Mail email client (which isn't on the internet, its an application for the PC) but I also installed Outlook thinking that might be more suited to the job. I created a Mail Merge document based on the query that compiles the information from the two tables but I'm not sure whether thats the way to go or whether the SQL should be determined in VBA when the button is clicked and then passed to the Word doc.

I also considered having a report to detail the information and then send the report so I'm open so suggestions as to which one is the better solution.

Thank you very much