Search results

It may. The SendObject works with Outlook and (I think) Netscape mail as long as it is configured right. Other then that I am not real sure so it may take some trial and error to get it working.

Basicaly all I need is the name of the table that holds the email addresses and the name of the field that holds the actual email address. Post that info and I will help you do the rest of the code and tell you where to put it.

susor does that path work when you navigate to it with Explorer?

Try this. I have never used it but I have heard that it works as advertised. A better mouse trap?

AlanT did you get this worked out then?

Modify your SendObject statement to something like this: Dim strEmail As String ' Use Me.YourTextbox name in place of the ' Me.txtEmailAdd in the following statement. strEmail = Me.txtEmailAdd DoCmd.SendObject , , , strEmail, _ , , "Subject Line", , True If you need to put multiple...

omoregbe, this is a very simplified example of what you are trying but I think it may be the first step you need to take to get this working for you. Try the following example but put your email address in place of the email@email.com Dim dtOne As Date Dim dtTwo As Date dtOne = Date ' If you...

deekras will this do the trick? Files It is not a direct solution but if I understand you correctly that should get you started.

Yea it was a little absent minded of me to say that without actualy asking for the info eh? Basically I was wondering whether there needed to be any clean up pre or post import. I wasn't sure if you needed to maintain the data already in the table and append new data to it or if you wanted to...

Ok there are a few things that I need to know to really make this answer useful but this may get you started: ' Turn the Access nags off DoCmd.SetWarnings False ' Import SpreadSheet and name the table ExcelImport DoCmd.TransferSpreadsheet acImport, 8, "ExcelImport", _...

Chewy will this do the trick? Automatically e-mailing a document

DrugBust did you get a chance to take a look at my demo and or use the code I posted?

Can you post the code?

<% Const adOpenStatic = 3 Const adUseClient = 3 Const adLockReadOnly = 1 Dim ConnStr connStr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" _ & Server.MapPath("/fpdb/database.mdb") Dim Rs Set Rs=Server.CreateObject("ADODB.Recordset") Rs.CursorLocation=adUseClient Rs.Open...

DrugBust I put some ASP code up real quick that basicaly does the same thing that your page is doing here. Check it out I am actualy using your own data. I added a few formatting tags to the table but you'll get the idea. Here is the asp code to do that. All you have to do is modify the...

Ok up front I have to say I would stay away from FP Database wizards at all costs. It is cleaner and better to use simple ASP. Having said that I think this will work for you <%=FP_FieldVal(fp_rs, ("<a href=mailto:") "USERID") & (">") & ("USERID") & ("</a>"%> However I didn't have a Front...

Kevin that should teach you not to put someone's name in a post again, eh? :D

Getting rid of the first line is where I got stuck. I have never been that great with string manipulation but isn't that how it should be done?

That is one ugly file. I am not sure whether an import can be automated for that one or not. I think it would take someone much better then I to decipher it though.

Yup. Create a new query for the table that holds the field you want to use. Then go into design view. Once there just go to the first blank column and add the NewField: "*" & [YourField] & "*" to the top row. NewField is the name of the field that will be created in your query and YourField...