JoeBo747
asked on
Report as HTML
I wish to send a report in the main body of an e-mail, I am currently sending the report as an attachment:
DoCmd.SendObject acSendReport, stDocName, acFormatHTML, imailadd, , , "results For" & " " & idist & " " & "From STC", , False
How would I alter the command to send the same report in the main body of the e-mail.
Any help appreciated
DoCmd.SendObject acSendReport, stDocName, acFormatHTML, imailadd, , , "results For" & " " & idist & " " & "From STC", , False
How would I alter the command to send the same report in the main body of the e-mail.
Any help appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have this issue in your original HTML output from your Report?
The code doesn't add anything to the HTML file, it reads it line by line and puts these lines together again.
The code doesn't add anything to the HTML file, it reads it line by line and puts these lines together again.
ASKER
No, the file created by your code is fine, it is only when the e-mail is opened that the format alters.
I am sorry Joe, No idea,
check if Word is ticked to be your default email editor, and if Word is doing this.
otherwise, you might want to post this issue in the Outlook area, the guys there are good.
check if Word is ticked to be your default email editor, and if Word is doing this.
otherwise, you might want to post this issue in the Outlook area, the guys there are good.
ASKER
Hi Jaffer
Thanks for your time, I am sure I will get to the bottom of this.
Points awarded
Joe
Thanks for your time, I am sure I will get to the bottom of this.
Points awarded
Joe
You are welcome Joe,
Sorry I couldn't make your day :o(
Sorry I couldn't make your day :o(
Just a thought. Perhaps the double spacing will disappear after email is sent. I think I've seen something like this before.
Steve
Steve
Hi Joe
Although you said points awarded, but I think you forgot to accept the answer, please do it.
thanks,
jaffer
Although you said points awarded, but I think you forgot to accept the answer, please do it.
thanks,
jaffer
ASKER
Hi Jaffer
Please accept my apologies. I thought I had closed the question, but it was late here! Just to let you know the message once sent arrived properly formatted! So yo did make my day O :)
Many Thanks
Joe
Please accept my apologies. I thought I had closed the question, but it was late here! Just to let you know the message once sent arrived properly formatted! So yo did make my day O :)
Many Thanks
Joe
Hey thats Great news, Steve was right in his thought.
Is it possible to have another report generate to PDF and added to the email as an attachment with this coding? If so, how?
ASKER
Thanks for you reply, works great apart from double spacing the text which I am unable to correct any suggextions.