C
Calendar_Tech
Is there a way to convert the rows in a .csv file to .ics files?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
Calendar_Tech said:Is there a way to convert the rows in a .csv file to .ics files?
Yes, please use attached link
http://www.google.com/search?hl=en&source=hp&q=csv+to+ics+format&btnG=Google+Search&aq=f&oq=&aqi=
C
Calendar_Tech
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.
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.
S
Sue Mosher [MVP]
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
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
C
Calendar_Tech
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.
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.
S
Sue Mosher [MVP]
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.
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.
C
Calendar_Tech
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.
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.
S
Sue Mosher [MVP]
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.
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.
C
Calendar_Tech
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
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
S
Sue Mosher [MVP]
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
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.