~Code tidy - Email

Glad we could help G.
 
Minor issue and I think worthy of adding to thread

I have this working on my home pc (magic...)
take it into the office


copy paste and Bamm - different

the difference is
single line spacing (at home)
so :
Insured :-whizzy
Event :-as declared
Dates :-01/01/2001 To 01/01/2001
Venue :-Various Locations

at the office
Insured :-whizzy

Event :-as declared

Dates :-01/01/2001 To 01/01/2001

Venue :-Various Locations
copy pasted the whole code
what gives
 
Versions of Access and OS will help.
 
A2003 and os system - eem not sure at work I think its xp -
I find out

G
 
Access 2003 in both sites?

I think one of them is reading the <blockquote> incorrectly or just differently. It could be a browser thing.
 
I have a proper look and mess around at work.. and see what the hell is going on ..
G
 
work
OS XP Pro
Version 5.1 2600 SP 3 build 2600


Access 2003
 
sorry for the delay
Windows 7 (Home Premium)
Version 6.1.7600
 
What are they using to open the e-mail though?

Can you upload a test db?
 
Sorry - late response
the guaitar was calling me and i need to thrash out a few tunes to settle myself...


Would not be too keen to upload the whole d/b -

so will strip out a few bits .....
 
You should know by now we never need the whole db. Just the relevant bits ;)

One table, one query and one form.
 
yeap I know - but thought I would do a little reasearch first

found this about outlook

The extra line spacing is caused by the interactions between Outlook and your editing application, such as Microsoft Office Word or Microsoft Office FrontPage®.

In the first signature example, when you pressed ENTER at the end of a line, a <br> tag was inserted in the code used for the signature. A <br> tag is used in HTML to create a line break. However, depending on which editing application you use to create your signature, a <p> tag (a paragraph tag) might be inserted. A <p> tag is interpreted by Outlook as a line break plus an extra line space


and also

Tools menu > Options > Preferences tab > E-mail options button > 'Remove extra line breaks in plain text messages'.

So i am going to try these first - as I like the code as it is now (after the tweaks you guys have done )

I will rip out bits if these two don't work


as I still would not be able to test it until I get to the office (at home at the moment ) listen to a bit of meatloaf ....
so hold fire on this as a simple click of an option in outlook at work could resolve the issue or possible renaming <p> to some other reference such as
Const XPX As String = "<P>"
may just get it past outlook

Outlook is good but can be stupid at the same time this might just fool it
 
--} Fingers crossed {--

Enjoy listening to your meatloaf!
 
on to the Cure "Boys don't cry"

will let you know .....
G
 
neither worked ..

I will rip out a sample


- but what i think i need is a delete/remove line

will revert laters

g
 
ripped and stripped d/b
my d/base looks nothing like this - this is enough to get it working ....bhal..

I think at the end of each line I need to somehow backspace and delete a return
 

Attachments

It just shows that it's been too long since I did any web development that I couldn't even spot the simple "invalid" xhtml tags. The problem dawned on me when I opened your db. <br> doesn't have a closing tag so writing <br> and </br> is causing two line breaks :)

You can write it as <br> or <br /> and I think XHTML is strict on the later.

See attached the changes.

NB: vbCrLf has no effect on your code in html.
 

Attachments

Users who are viewing this thread

Back
Top Bottom