Recent content by BrianB75

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...