Third party attach .txt file

  • Thread starter Thread starter AMT
  • Start date Start date
A

AMT

Hello Everyone,
I have a third party email notification
program that attaches a .txt file that draws information
from different rows on SQL database located on the same
Server (see attached file for coding. How can I edit this
file in order to change where the .txt file is pointing
to. e.g (if i wanted to add Duration: [duration time]
pointing to the value in the SQL dbase.

thank you in advance
AMT

Confirm1aa.txt
------------------------------------------

Reference No : [RNUM]
Date : [DATE]
Time : [TIME]
Company : [CMNAME]
Email Address : [EMAILADR]
Attention : [NAME]

------------------------------------------

Conference Confirmation

Your conference booking has been confirmed for [LOCALDATE]
at [LOCALTIME].

Your conference call is booked as follows:

* Conference name: [CNAME]
* Scheduled Conf Date: [LOCALDATE]
* Scheduled Conf Time: [LOCALTIME] [TZONE]
* Conference Reference: [CNUM]
* Number of participants: [CFREES]
* Dial-in Number: [DDI]
* Moderator Pin access code: [MPIN]
* Participant Pin access code: [CPIN]

------------------------------------------

Here are the calling instructions for your DIAL-IN
conference.

1. Dial [DDI] and follow the voice prompts.
2. At the voice prompt, press the Conference Code [PIN]
and the # key.
3. You will be connected to the conference if your
Conference Code is correct. Otherwise, you will be
transferred to a conference operator for assistance.
4. Press * and 0 for the assistance of a conference
operator during the conference.
5. If you are disconnected for any reason, you can dial
[DDI] and Conference Code [PIN]

------------------------------------------

Contact: [CHAIRNAME] MAILTO:[CHAIREMAIL]

[SYSOWN1]
[SYSADR1]
[SYSADR2]

[FTEXT]
 
Try posting in a SQL group; this doesn't seem to be related to Outlook.
Seems to me that you'd need to know the field name for the duration field in
the SQL table.
 
ok thanks..i'll try that
-----Original Message-----
Try posting in a SQL group; this doesn't seem to be related to Outlook.
Seems to me that you'd need to know the field name for the duration field in
the SQL table.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Hello Everyone,
I have a third party email notification
program that attaches a .txt file that draws information
from different rows on SQL database located on the same
Server (see attached file for coding. How can I edit this
file in order to change where the .txt file is pointing
to. e.g (if i wanted to add Duration: [duration time]
pointing to the value in the SQL dbase.

thank you in advance
AMT

Confirm1aa.txt
------------------------------------------

Reference No : [RNUM]
Date : [DATE]
Time : [TIME]
Company : [CMNAME]
Email Address : [EMAILADR]
Attention : [NAME]

------------------------------------------

Conference Confirmation

Your conference booking has been confirmed for [LOCALDATE]
at [LOCALTIME].

Your conference call is booked as follows:

* Conference name: [CNAME]
* Scheduled Conf Date: [LOCALDATE]
* Scheduled Conf Time: [LOCALTIME] [TZONE]
* Conference Reference: [CNUM]
* Number of participants: [CFREES]
* Dial-in Number: [DDI]
* Moderator Pin access code: [MPIN]
* Participant Pin access code: [CPIN]

------------------------------------------

Here are the calling instructions for your DIAL-IN
conference.

1. Dial [DDI] and follow the voice prompts.
2. At the voice prompt, press the Conference Code [PIN]
and the # key.
3. You will be connected to the conference if your
Conference Code is correct. Otherwise, you will be
transferred to a conference operator for assistance.
4. Press * and 0 for the assistance of a conference
operator during the conference.
5. If you are disconnected for any reason, you can dial
[DDI] and Conference Code [PIN]

------------------------------------------

Contact: [CHAIRNAME] MAILTO:[CHAIREMAIL]

[SYSOWN1]
[SYSADR1]
[SYSADR2]

[FTEXT]
Click to expand...


.
Click to expand...
 
Back
Top