When using VBA to send a report via email, you can Include a message text,
the trouble is formatting this text to look good by, adding in a secret
command to jump to the next line
eg:
DoCmd.SendObject acSendReport, "rptEmailInvoice", "html", Me.CustID, ,
"Jphoto invoice", "Thank you for using jphoto" ***Secret command to make it
go to new paragraph*** " lease find your invoice attached", True
Thanks any help would be greatly appreciated
Justin 3 16192
just wrote: When using VBA to send a report via email, you can Include a message text, the trouble is formatting this text to look good by, adding in a secret command to jump to the next line
eg:
DoCmd.SendObject acSendReport, "rptEmailInvoice", "html", Me.CustID, , "Jphoto invoice", "Thank you for using jphoto" ***Secret command to make it go to new paragraph*** " lease find your invoice attached", True
Thanks any help would be greatly appreciated
Justin
"Thank you for using jphoto" & Chr(13) & Chr(10) & " lease find your
invoice attached",
:)
--
regards,
Bradley
Bradley is correct.
You can use vbCrLf or vbNewLine as constants for the same thing.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40********@nexus.comcen.com.au... just wrote: When using VBA to send a report via email, you can Include a message text, the trouble is formatting this text to look good by, adding in a secret command to jump to the next line
eg:
DoCmd.SendObject acSendReport, "rptEmailInvoice", "html", Me.CustID, , "Jphoto invoice", "Thank you for using jphoto" ***Secret command to make it go to new paragraph*** " lease find your invoice attached", True
Thanks any help would be greatly appreciated
Justin
"Thank you for using jphoto" & Chr(13) & Chr(10) & " lease find your invoice attached",
:) -- regards,
Bradley
Thanks
Muchly
Justin
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au... Bradley is correct. You can use vbCrLf or vbNewLine as constants for the same thing.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message news:40********@nexus.comcen.com.au... just wrote: When using VBA to send a report via email, you can Include a message text, the trouble is formatting this text to look good by, adding in a secret command to jump to the next line
eg:
DoCmd.SendObject acSendReport, "rptEmailInvoice", "html", Me.CustID, , "Jphoto invoice", "Thank you for using jphoto" ***Secret command to make it go to new paragraph*** " lease find your invoice attached", True
Thanks any help would be greatly appreciated
Justin
"Thank you for using jphoto" & Chr(13) & Chr(10) & " lease find your invoice attached",
:) -- regards,
Bradley
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Peter A. Schott |
last post by:
Per subject - I realize I can copy/paste a line at a time into an interactive
session when I'm trying to debug, but was wondering if there is any tool out
there that allows me to copy sections of...
|
by: Skybuck Flying |
last post by:
Hi,
I needed a method to determine if a point was on a line segment in 2D. So I
googled for some help and so far I have evaluated two methods.
The first method was only a formula, the second...
|
by: DraguVaso |
last post by:
Hi,
For my application I need the following behavior: When I press F4 the cursor
has to move to the next line in my multiline textbox which begins with "0".
Finding lines starting with 0 isn't...
|
by: Double Echo |
last post by:
Hi all,
I'm using PHP 4.4.2, and use PHP on both the command-line and the web.
I am running PHP on SuSE 10 Linux , in a VMware 5.5 workstation, using
Apache 2.0.55 , on my Dell laptop. ...
|
by: Adi |
last post by:
Hello eveyone,
I wanna ask a very simple question here (as it was quite disturbing
me for a long time.)
My problem is to read a file line by line. I've tried following
implementations but still...
|
by: magix |
last post by:
Hi,
when I read entries in file i.e text file, how can I determine the first
line and the last line ?
I know the first line of entry can be filtered using counter, but how about
the last line...
|
by: Jacob Rael |
last post by:
Hello,
I have a simple script to parse a text file (a visual basic program)
and convert key parts to tcl. Since I am only working on specific
sections and I need it quick, I decided not to...
|
by: WStoreyII |
last post by:
the following code is supposed to read a whole line upto a new line
char from a file. however it does not work. it is producing weird
results. please help. I had error checking in there for...
|
by: xdevel |
last post by:
Hi, I don't understand option.
if I write:
#line 100 "file"
I change file numeration to start to line 100 but what "file" ?
any example?
|
by: =?Utf-8?B?QnJpYW4gQ29vaw==?= |
last post by:
This is an example of the data;
2007/07/27 11:00:03 ARES_INDICATION 010.050.016.002 404.2.01 (6511)
RX 74 bytes
2007/07/27 11:00:03 65 11 26 02 BC 6C AA 20 76 93 51 53 50 76 13
48...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |