Search results

I have to create a string either in a query or on a form (which hopefully can update a query). There is one numeric constant (1234) and another figure that comes from the input spreadsheet (Office -WXYZ) and in between them three variables. My big dilemma is that some branches have a “W” in...

I'm using an Access form to populate an Outlook email template. I have been successful getting the data from the form into an email using this sequence Body = Replace(Body, "@1", Me.[BUREAU CODE]) with a control source tied to a specific table or query. My problem is one of my form fields...

I'm using an Access form to populate an Outlook email template. I have been successful getting the data from the form into an email using this sequence Body = Replace(Body, "@1", Me.[BUREAU CODE]) with a control source tied to a specific table or query. My problem is one of my form fields...

I need to send an outlook template as an email from Access. When I use the code below it hangs up at “CreateItemFromTemplate” and I keeping an error message - “Compile Error: Method or data member not found.” I have the following references checked: Microsoft Access 14.0 Object Library...