Solved

Carriage Return needed in body of VBSCRIPT generated e-mail message

Posted on 2004-04-22

Microsoft Access

1 solution

1,010 Views

Last Modified: 2007-12-19

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.value & "?subject=" & "Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value
------------------

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.....

Comment

Question by:westermo

[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

Join The Community

12 Comments

LVL 65

Expert Comment

by:rockiroads

ID: 108875722004-04-22

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.value & "?subject=" & "Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value & vbcrlf & "XXXX"

this would add XXXX on a new line

try it in this

LVL 2

Author Comment

by:westermo

ID: 108876232004-04-22

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?

LVL 65

Expert Comment

by:rockiroads

ID: 108876332004-04-22

is it possible to output this?

\r\n

LVL 2

Author Comment

by:westermo

ID: 108876432004-04-22

Syntax error shows when using \r\n as follows

window.open "mailto:" & DropDownList_Sales_Staff.value & "?subject=" & "Westermo UK Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value & \r\n & "dummy text"

LVL 44

Expert Comment

by:Arthur_Wood

ID: 108876852004-04-22

should be:

window.open "mailto:" & DropDownList_Sales_Staff.value & "?subject=" & "Westermo UK Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value & "\r\n" & "dummy text"

LVL 65

Expert Comment

by:rockiroads

ID: 108876922004-04-22

\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

LVL 2

Author Comment

by:westermo

ID: 108877132004-04-22

Thanks and sorry guys, because its surrounded by quotes, it displays in the body message as follows:

Company Name: Bloggs & Co\r\ndummy text

LVL 1

Accepted Solution

by:dssdb

dssdb earned 125 total points

ID: 108878442004-04-22

Try This..

window.open "mailto:" & DropDownList_Sales_Staff.value & "?subject=" & "Westermo UK Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value & "%0D%0A" & "dummy text"

LVL 65

Expert Comment

by:rockiroads

ID: 108878682004-04-22

is it possible to define a string first

x = "..." & vbcrlf & "..."

window.open ... & x

LVL 17

Expert Comment

by:aflockhart

ID: 108879702004-04-22

Maybe this ?

window.open "mailto:" & DropDownList_Sales_Staff.value & "?subject=" & "Westermo UK Technical Support Ref: " & ID.value & "&Body=" & "Company Name: " & Company_Name.value & chr(13) & chr(10) & "Contact name etc"

LVL 2

Author Comment

by:westermo

ID: 108880052004-04-22

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

Expert Comment

by:sparky__

ID: 111060162004-05-19

cheers.. %0D%0A worked a treat... the ms knowlege base lies i tel ya!! they suggest using Line1%250dLine2 but that just comes up with Line1%0dLine2

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an Access Database Taskbar Item in Windows 7 through 10

Article by: Helen

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.

Microsoft Access

Finding the Office Templates Folder

Article by: Helen

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …

Access Desktop Databases – A Quick Tour

Video by: Jim

What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

Microsoft Access

MS Access – Different Ways to Start Up a Database

Video by: Jim

With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…