Search results

Also wanted to say that jollofrice's post helped me solve my issue.

Thanks again. I was trying to avoid that but it is better code to use so I'm just going to bite the bullit and update my code. On the plus side, it will give me the oppertunity to clean up my old marcos/code a bit. :)

That mess of code was just a sample I was using to test out the new PC. Almost all of my older code uses only the docmd, and then typically directly in a macro and not in code. Oddly, I get no messages from either Access or Outlook but then I do have the Trust Center setup so that the database...

That is what I am afraid of...;) I am just confused on what changed in either Access 07 or Outlook 07 compared to Office 2002 that caused this to stop working correctly.

Here is an odd one. I have quite a few reports that have been running fine for years on an older WinXP PC (Office 2002). Since switching to a Win7 PC, all of the reports that are sent via SendObject (either in a macro or in a module) are being created correctly but get stuck in Outlook's...

Just as a follow-up I ended up using the GetNameSpace function: Set obEmail = CreateObject("Outlook.Application") Set mynamespace = obEmail.GetNamespace("MAPI") Set obMsg = obEmail.CreateItem(olMailItem) mynamespace.Logon "ProfileName", , , True Had our IT department set up a new e-mail...

I am currently working on a database that will be sending out multiple reports but they need to be sent from different e-mail profiles. I have the two profiles set up but I am at a loss with how to select which profile to use in my code. Here is a sample: Dim obEmail As Object, obMsg As...

Just wanted to say thanks for posting this information. This has worked great and save me quite a few headaches. :)

Just as a follow-up I tried the set value but that did not seem to work.

I might be biting off more than I can chew but here goes. I have a form where the Detail displays a list of records with some basic data and the Form Header lists more detailed information for the record that is selected in the Detail. What I would like to do is format the Detail fields so...

Worked great! Thanks for the help Philo! This was even better than trying to use an Exchange folder as we have a table that contains the vendor's info, including fax.

I received an interesting request today and was hoping someone here could help. Using Outlook here one of the managers set up a Contact List folder under our public folders to store vendor contacts. These will be used as faxes instead of e-mail though. We are using RightFax, of which I have...

I think I may have found a different way of doing this. Basically I am exporting it to Word and then copying and pasting it into the e-mail body. Now I just cannot figure out how to do the paste part. If anyone has any ideas here is the thread...

I am trying to copy the text from a Word doc created from a Report to the body of an e-mail that has been opened in VB. I was able to open the Word doc, select all the text and copy it but now I cannot figure out how to paste it into the body of the e-mail. Any help with this one? Also, once...

I ended up using underscores for the lines and it worked out well. The wired thing is that when the code exports the html file the formatting looks fine, its when it imports it into the e-mail that things start acting up. It appears that it is adding double spaces between all of the lines...

Snapshot viewer actually isn't a problem as everyone in our office has it installed. The issue is that the requirements for this report state that it needs to be displayed in the body of the e-mail and not as an attachment. I thought about the pdf route but I don't think I could pull that into...

The above solution appears to work for me but some elements of the report are not being displayed. I attached the test report in a snapshot format and also the HTML output. I cannot figure out why the two horizontal lines and the picture are not outputting. Could someone give me a heads up as...

Thanks for the responses. I do not have the report formatted yet as I wanted to make sure I could get this to work. I do not have Front Page and I am not familiar with HTML coding. When I spoke of HTML in my original post I was just using the OutputTo in VB to create the HTML file based on a...

I have searched through the various means of adding an Access object in the body of an e-mail but I cannot seem to find something that works. What I am trying to do is embed an existing, formatted report from Access into the body of an e-mail. I tried exporting the report as a .html file but...

I found a workaround. I didn't actually need the SetValue command as the detail form's query is using criteria based on the active record on the main form. By removing the SetValue and just minimizing the main form when the Detail form is loaded the record position is saved. Then, when the...