Search results

Hi, I have a bookmark in my word document. In the code, I need to attach few files into the bookmark. What I am trying to achieve is the following: For each attachment, add a line to the range of bookmark saying "Attachment1" and so on; and also insert a page break after the previous...

Thanks! It worked!

Hi, I am trying to insert a PDF File (as attachment) into a Bookmark in the Word Document. How do I do it? Following is the code I used, but it doesnt seem to work: FileSystemObject.CopyFile sourcefile, appDoc.bookmarks("Bookmark1").Range Thanks

Ok, then I suppose the style with "type" is not supported in Access. Thanks for the reply. I will try to find an alternative.

Yes, it is a Rich Text control

Hi, I am trying to use HTML tags in an Unbound Text box for Bullets (with specific type) and Indentation. I used the following: ="<ul style='list-style-type:square'> <li>UL List1</li> <li>UL List2</li> <ol type = 'A'> <li>OL List1></li> <li>OL List2></li> </ul>" I am getting the default lists...

The font style helped! Thanks a lot

Hi, I am trying to create a report footer to include the symbol of a telephone, along with other text. How do I do it? Also, how to create a text box with 2 columns - similar to have a 2 page view in a book? Thanks in advance WS

I was being so careless!! :banghead: I was giving the "strFilter" as the wrong argument while opening report This worked: DoCmd.OpenReport "rptTest", acViewReport, , strFilter

Hi Minty, That link was quite helpful. Now I got the logic to work. However, I have another small problem. When I click "Filter" (as shown in the sample database), I am opening a report. DoCmd.OpenReport "rptTest", acViewReport, , , , strFilter Although strFilter has the right...

Thanks! let me go though it now

Hi, I have a form with 6 combo boxes in it. I have a command button, which should display the query results when clicked. Now, my challenge is to build the query based on the 6 different fields. ie. query should be: WHERE Field1 = "Value" AND Field2 = "Value" AND FIELD3 = "Value" AND FIELD4...

Hi Grumm, Thank you very much. I wrote the following code and now it works!!!!! Function GetDistLists() 'Get all the Distribution Lists in the Contacts Folder of Outlook and get the email IDs out of them into a string Dim objOutlook As Outlook.Application Dim objNameSpace As...

Hi Ginawhipp, The version of MS Office that I am using is 2013. Hi Minty, Sorry about not being clear. Yes, when I say Distribution list, it is a contact group in my outlook. I added the code as you suggested, and I get the following msgbox "Test could not be resolved" Thanks

Hi Grumm, I was doing as you said. Since I have a huge distribution list, which keeps changing often, I wanted to try the option of using the Distribution List directly in the code, so that I wont have to edit the code each time when the list changes. Thanks

Yes, it opens up. In the 'To; field, it has the word Test. Not the emails in the Test Distribution list. How can I find out what bit of Microsoft Office I am using?

Version of Access - Access 2013 Version of Outlook - Outlook 2013 Outlook is Open Version of Windows - Windows 7 Professional Operating Sytem - 64 bit

I tried the code exactly as you said. Funny enough, I don't get any error message, but it does not send the email either! I checked my sent items, inbox. What could be happening?

When I code: .To = "Test" I am getting the following error message: "Access does not recognise on or more names" and it stops at .Send It does not send the email.

it didn't work! I have a distribution list named 'Test' in my outlook. In my code I used the following: Dim OL As Outlook.Application Dim MyMail As Outlook.MailItem Set OL = Outlook.Application Set MyMail = OL.CreateItem(olMailItem) With MyMail .To = "Test@MyDomain.com"...