Search results

Just tested the following code using Access 2010 and Outlook 2010 and seems to workk fine - Good luck Private Sub Command223_Click() RunCommand acCmdSaveRecord DoCmd.OpenReport "EstimatePrint", acViewReport, , "[EstimateID]=" & [ID] DoCmd.OutputTo acOutputReport, "EstimatePrint", acFormatPDF...

Thanks for that, just what I need

I have a form which creates new 'estimates', when someone completes the form there is a field 'e-mail address'. Is it possible to lookup the Outlook Address Book and retrieve the email addresses in a Combo box ??

You're right I shouldnt be attempting this at all. I picked up some old code. Thanks for the help

I have the following piece of code which runs when a user exits a particular record. On checking the Database i find that this hasnt occurred on some occasions and my data therefore is incorrect, can someone tell me how I would run this code against ALL records in my database, as a macro...

What is wrong with the following expression :- [Customer]=10 And [PO_Number]IsNull I'm trying to highlight a field were this condition is true ??

I've resolved the issue by placing my image(logo) on the web and referencing to that rather than to my local machine. Here's the amended version of your code. Thanks for all your help. Private Sub Command223_Click() RunCommand acCmdSaveRecord DoCmd.OpenReport "QuotationPrint", acViewReport, ...

I have managed to add a signature with some code I found on the forum. However, my signature is an HTM file which contains some images(logos). When Outlook is already running it displays the images(logos) fine, when Outlook is NOT running I get a red cross and an error message 'The image part...

Thanks to ghudson. That piece of code works fine using an existing Outlook session if there is one, alternatively creating a new session. I'm trying to work out how to add a Signature now. Any help would be appreciated !!

Thanks for your efforts. The error you are getting I think is because you need to add Outlook 12.0 to the references. If you havent got Outlook 2007 it's impossible to replicate. Thanks anyway

I attach a cut-down version of my Access 2007 Database. I have put your amended code within it. If you call up the Form 'Quotations List' then select a record, one of the buttons on the top calls a routine to 'e-mail the quotation' As mentioned previously I use Outlook 2007 Good Luck

Ran the code with F8 objdoc and objInsp both set to Nothing. What do they need to be set to ???

Thanks I tried that but I get an error further down the routine :- Set objdoc = objInsp.WordEditor If objdoc Is Nothing Then strmsg = "Outlook must use Word as the email editor. Follow these instructions to fix the problem." & vbCrLf & vbCrLf & _...

I am using the following code which I found on this site to generate e-mails from within my application. It works fine except a creates another session of Outlook everytime I call the routine even if I already have Outlook running. I'm using Access 2007 and Oitlook 2007. Public Function...

I have just inserted the above code in a routine on my DB and it works fine. The only issue I have is that it creates a new session of Outlook when there is already one running. I wish the messages to be viewed and edited prior to sending so I dont want to autosend them. Do you have a work...

I have a piece of code that generates an Outlook email message together with an attachment (PDF file). I also add my Outlook signature which contains text and company logos. The text displays fine but I get the following error message instead of the logos ' The image part with relationship ID...

I have 2 Tables - Property and Service I want to add a new Service Record attached to my Property Record. Key for Property Table is PropertyID Key for Service Table is ServiceID The records in Service Table also contain a field PropertyID which is the link/relationship between the tables...

Thanks that's sorted the problem

Not sure what the full path is !! The PDF "Estimate Print" is a temporary printfile created earlier in the function

I’m trying to attach a PDF (EstimatePrint) as an attachment to my Outlook Message. Everytime I run it, it just hangs Outlook with NO errors. I assume I’m not referring to the PDF correctly ??? If I take out the Add.Attachment it works fine !! The code is below, any help would be appreciated...