Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Carriage Return needed in body of VBSCRIPT generated e-mail message
Posted on 2004-04-22
Hi Experts, I am using a Data Access Page with a button to generate a mail message and populate the TO, SUBJECT and BODY areas. The code below works fine, but I need to ammend it in some way that will include the [Contact_Name] field on a new line (carriage return) under the [Company_Name].
This is what I have sof far:
------------------
window.open "mailto:" & DropDownList_Sales_Staff.v
------------------
Which displays the following in a new message, ready for the user to click the 'Send' button:
------------------
To: Sales Staff Name
Subject: Technical Support Ref: 1234
Message Body:
Company Name: Bloggs & Co
------------------
I would like to display the [Contact_Name] on the next line e.g.
Company Name: Bloggs & Co
Contact Name: Joe Bloggs
Please help.....
This is what I have sof far:
------------------
window.open "mailto:" & DropDownList_Sales_Staff.v
------------------
Which displays the following in a new message, ready for the user to click the 'Send' button:
------------------
To: Sales Staff Name
Subject: Technical Support Ref: 1234
Message Body:
Company Name: Bloggs & Co
------------------
I would like to display the [Contact_Name] on the next line e.g.
Company Name: Bloggs & Co
Contact Name: Joe Bloggs
Please help.....
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
- +3
12 Comments
hello again, lets hope they dont change the design again eh, lol
In vb you would add VBCRLF or VBCR
window.open "mailto:" & DropDownList_Sales_Staff.v
this would add XXXX on a new line
try it in this
In vb you would add VBCRLF or VBCR
window.open "mailto:" & DropDownList_Sales_Staff.v
this would add XXXX on a new line
try it in this
Hi rockiroads !!
Would have been a perfect quick solution BUT.... it doesn't work :( Neither vbcr or vbcrlf made any difference - not even an error message. Funnily enough I can replace either with any text and it's just ignored.
Thanks tho, Any other ideas?
Would have been a perfect quick solution BUT.... it doesn't work :( Neither vbcr or vbcrlf made any difference - not even an error message. Funnily enough I can replace either with any text and it's just ignored.
Thanks tho, Any other ideas?
Syntax error shows when using \r\n as follows
window.open "mailto:" & DropDownList_Sales_Staff.v
window.open "mailto:" & DropDownList_Sales_Staff.v
should be:
window.open "mailto:" & DropDownList_Sales_Staff.v
window.open "mailto:" & DropDownList_Sales_Staff.v
\r\n is a string, like Arthur has done, it has to go into quotes,
Im not sure if it will work, but give it a shot
Im not sure if it will work, but give it a shot
Thanks and sorry guys, because its surrounded by quotes, it displays in the body message as follows:
Company Name: Bloggs & Co\r\ndummy text
Company Name: Bloggs & Co\r\ndummy text
Try This..
window.open "mailto:" & DropDownList_Sales_Staff.v
window.open "mailto:" & DropDownList_Sales_Staff.v
Maybe this ?
window.open "mailto:" & DropDownList_Sales_Staff.v
window.open "mailto:" & DropDownList_Sales_Staff.v
Hey guys Thanks for all your help. Colleagues of mine tried the chr 10 and 13 but these were also ignored.
:D dssdb has hit the nail on the head with this one with his advice as follows:
"%0D%0A"
This works a treat - so it's only fair I give him the points - hope you all agree. Many thanks to ALL of you. Until next time rockiroads :D I'm sure....
Thanks again
:D dssdb has hit the nail on the head with this one with his advice as follows:
"%0D%0A"
This works a treat - so it's only fair I give him the points - hope you all agree. Many thanks to ALL of you. Until next time rockiroads :D I'm sure....
Thanks again
Featured Post
Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month11 days, 3 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.