convert rows in .csv file to .ics files

  • Thread starter Thread starter Calendar_Tech
  • Start date Start date
Perhaps I wasn't clear. I would like a .ics file, calendar or meeting
request file created from each row in the .csv file. I want to create dozens
of meeting requests files from the data in the .csv file. Thanks.
 
It's still not clear exactly what you're trying to accomplish. Do you mean
that you want to start with a .csv file and from that, generate and send a
meeting request for each row in the file? Nothing is built into Outlook to do
that, but it could be done with VBA code. Is the recipient information also
in the file? Or is it coming from some other source?

FYI, there is a newsgroup specifically for general Outlook programming
issues "down the hall" at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba
 
I'm trying to create meeting request files from data within a .csv file. I
have the meeting date and time, reminder time, required attendee and
description on each row of the .csv file. Let's say that I have 10 rows of
data. I would then like to see an output of 10 meeting request files.

I found a sendmail add-in here which allows to send from Excel.
http://www.rondebruin.nl/mail/add-in.htm

If I don't need to use the Excel add-in that would be great. What do you
suggest to make this process more scalable? Thanks.
 
I don't see anything in that add-in's description that suggests it can
generate meeting requests. As I said before, you'd need to write code to do
this, parsing the .csv file, which can be done by using Excel methods, and
then iterating the rows to generate each meeting request. There's a code
sample at http://www.outlookcode.com/codedetail.aspx?id=88 that demonstrates
how to create a meeting request programmatically.

What are your scalability concerns? 10 rows doesn't sound like much to
process.
 
Sue, that appears to be along the lines of what I want to accomplish. I
have zero experience coding since Cobol back in the day so how would I go
about doing a find and replace with the example code and the data I already
have for the individual appointments? Thanks.
 
I don't see how find and replace would play any role. Are you saying that you
don't understand the code? I can help if there's something specific you don't
understand, but I don't really have the time to write out an explanation of
every statement.
 
I understand and appreciate your assistance. What part of the code would I
need to change to make set an appointment for (let's say) 10/16/09 at 3:00:00
PM with a reminder of 2 days? Thanks
 
Most property names are self-explanatory. In this case, you're interested in
the Start property. Date literals in VBA are formatted with hash marks, e.g.:

.Start = #10/16/2009 3:00 p.m.#

When in doubt about the name of a property, check the object browser: Press
ALt+F11 to open the VBA environment in Outlook, then press F2. Switch from
<All Libraries> to Outlook to browse all Outlook objects and their
properties, methods, and events. Select any object or member, then press F1
to see its Help topic. If you look up AppointmentItem, for example, you'll
soon learn that two key properties control reminder behavior; thus, you could
add to the code example:

.ReminderSet = True
' 2 days times 24 hours times 60 minutes
.ReminderMinutesBeforeStart = 2 * 24 * 60
 
Back
Top