Search results for query: *

This is the way I've done it.... ' Open Outlook for our own device.. Set MyOutlook = New Outlook.Application ' Create the e-mail Set MyMail = MyOutlook.CreateItem(olMailItem) ' Address it MyMail.To = DLookup("ParamSendTo", "tblParameters") MyMail.SentOnBehalfOfName = DLookup("ParamSendFrom"...

Try this......... Dim D1 As Long D1 = date2 - date1 NewDate = date1 + (D1 / 2)

Use .display instead of .send This will display the e-mail and you can change or add recipients prior to sending it.

Go into the VBA code code behind any form or report. Click Tools, References and check that the ticked items are the same on both systems.

The way I did this originally was to design a form which extracts the desired recipients - I put a Yes/No field on the form to highlight the relevant records - and then attach the code to a command button on the form.

This is my layout for tblEMails:- Surname Text Forename Text Title Text (Mr Mrs etc) E-Mail Text (E-Mail Address) Division Text (Used at an earlier stage to select from a main table - not really relevant or necessary here) EMail Flag Yes/No My original database extracts...

The EMailFlag is simply a Yes/No type field in the table which can be set or cleared by ticking/unticking a box on a form bound to the table. It simply allows the user more control in selecting to whom the emails are to be sent rather than only offering the option to send to everyone in the table.

Sorry - it's not that clever! The code just allows you to use a text-only e-mail template, such as a Notepad file.

The code sample allows one file to be attached - it doesn't really matter what it is. If you want to embed pictures within a Word document and then attach the word document to the e-mail it should still work.

Have you got the Microsoft DAO 3.6 Object Library ticked? There are several different versions of this library.

Strictly speaking it's safer to have the log files on a different drive so that the information store can be rebuilt in the event of a crash (not that Microsoft systems ever crash!) Navigate to Servers, Servername, Properties, General and you can specify there that log files should be deleted...

1. Open up the Exchange System Manager 2. Navigate down to Servers - Server Name - Domain Name 3. Right click the Domain Name and click Properties 4. Click Browse and choose the location where you want to place the log files 5. Click Apply and it will do it for you

Use the fields being input by the user to find the corresponding data in the relevant table(s) by using DLookup

Dear asafb, Try this; the code has been slightly changed around to concatenate a list of users. I've also put in a default .txt file name for the e-mail body and a default .doc file for an attachment. Option Compare Database Option Explicit ' You need to declare a reference to the Outlook...

Dear asafb, Glad the code did the trick .... Not sure whether you can generate just one e-mail with all of the recipients in the "To" box, but I appreciate that it's a bit of a pain that Outlook keeps on warning you that another application is trying to send mail. If you change...

Several users on an MS Exchange 2000 system need to collect mail when they are off site. Until they get a fast internet connection installed and can then use OWA I have set up mail-enabled contacts to forward their mail to their personal external e-mail addresses and also to leave it in the...

Try something like this attached to a command button. It will send the mail via MS Outlook ....... Option Compare Database Option Explicit ' You need to declare a reference to the Outlook library, and the filesystemobject. ' ' Look in the menu above, and click Tools, then select References ' '...

This is NOT a DNS problem. Try this link ...... http://support.microsoft.com/default.aspx?scid=kb;en-us;329457

I tried this .... http://www.brienposey.com/kb/XP_Network_Problems.asp and it worked on one network but not on others where the same problem existed. Any more ideas, anyone?

I've got this problem as well. Both MS Word and MS Excel (Office XP) can take up to a minute to save files and the PC is locked when it happens. The PCs are running XP Pro and are saving to Compaq Win2K Fileservers (high spec) across a 100Mb network. I've noticed in Computer Management on the...