Search results for query: *

Just when I thought I was finished, I have another question. I'm now trying to create the body of the appointment and want Bold text with different font colours. I understand that the body can only be in rich text format which (from what I have read) is painful. So I thought I would create...

Excellent Many Thanks to all who have helped

Sorry another question I cannot find the correct code to add recipients Is this something you can help with Thanks

Hi Not sure what I did but I think I've solved it Here is my latst code Sub CreateMeeting_Click() Dim ol As Object Dim Item As Object Const olAppointmentItem = 1 'item As AppointmentItem Set ol = CreateObject("Outlook.Application") Set Item = ol.CreateItem(olAppointmentItem) rDate =...

A short update If I paste the code into Outlook VBA it runs fine Although there is no value in rDate it defaults to a date in 1899 but the appointment is created Thanks

Hi Skip Thanks for your response rdate picks up a date value from a cell on the worksheet. The format of the cell is set to a date which results in the rdate value being 21/06/17 Also If I mark this line as a comment and allow the code to run to the next line (Item.Duration = 60) I get the...

Hi Thanks for your help so far Are there any other approaches I can use to creat an outtlook calendar

21/06/17

Hi thanks for your help I think this change works but I'm now getting the message 'Object doesn't support this property or method' When I click the Debug it highlights this line item.Start = rDate + TimeValue("8:30") Thanks

Thanks for the advice I check the reference library and I'm currently have "Microsoft Office 14.0 Object Library ticked in the reference library. I cannot find Microsoft Office 12.0 Thanks

Can anyone please help I am trying to create a calendar appoint with VBA from excel and have been searching for a solution I've tried a number of codes but nothing seems to work. I'm a bit of a novice so hoping that someone could help me My current code is below I get the following message -...

Skip / Andy Thanks for your help. I have changed a couple of things that fit my spreadsheet. For example, the column to be searched is B and I am really searching for the word SEND and not DAVE However, I still cannot get the email part to work Outlook does not even open up As you can see I...

Hi Can anyone help. I am a relative newcomer to VB and am trying to find / write some code to do the following I have an excel workbook with a worksheet that has two columns entitled, “firstname” and “Surname" I would like to search the column A (firstname) based on criteria and then drop the...

Xwb I know you helped me before but I am now tring to set the font size for the HTML Body but cannot seem to find the correct approach If you or anyone else could help again that would be great Thanks

xwb Excellent advice !. This works Many thanks

Thanks xwb I'll give this a try and let you know if this works Thanks

Xwb Thanks for you help. Would you be able to give some advice about the correct syntax Thanks

To Anyone who can help I have created some code from within excel that uses a command button When the command button is clicked in excel in creates an email message and this works fine However, I would like to change some of the text in the email to Bold and Red If someone could give me...

MaJP Country Setting is English (United Kingdom) I put an ubound text box on a form and set to date and it worked fine Skip I think the answer is yes thanks both for your help

The control is set to Auto