Email Attached PDF created incorrectly

[Varzoth]

If anyone can help me with this I'd really appreciate it.
On a report, I've made if a user prints (saves) it as a PDF it works fine, but if they use the option to have it attached to an email it adds in weird characters.

Normal one:

https://imgur.com/a/uBCqINR

command :
DoCmd.RunCommand acCmdPrint

Odd characters:

https://imgur.com/a/7Xk8CFo

command:
DoCmd.SendObject acReport, "TechVisitReport", "PDF", "", "", "", "Visit Report for: " & Forms!techVisitReport!Combo67 & ", Date: " & Forms!techVisitReport!Text17, "", True, ""

Is there a way to fix this or a way around the issue to attach a non-screwy pdf to an email?

 

[Ranman256]

The format parameter is not a string,it is:
AcFormatPdf

 

[Varzoth]

HI Ranman,

Thanks for your message

As in change the "PDF" to AcFormatPdf ?

Just tried this, still the same error

 

[Ranman256]

You can't have asterisk in filename

 

[Varzoth]

There isn't

 

[Ranman256]

you cant have colon in filename

 

[theDBguy]

Hi. Welcome to AWF!

If you manually save the report to PDF using the Ribbon buttons, do you still get the odd characters?

 

[GinaWhipp]

Hmm, the only time I have seen those is if there are Line Breaks. Is that what is happening here?

 

[Varzoth]

Just for closure, the issue was some kind of hidden character form people copy-pasting from word. I resolved the issue by changing the text boxes from pain to rich text. I guess you could also write some VBA to remove any hidden chars.

 

[theDBguy]

Just for closure, the issue was some kind of hidden character form people copy-pasting from word. I resolved the issue by changing the text boxes from pain to rich text. I guess you could also write some VBA to remove any hidden chars.

Hi. Thanks for the update. Good luck with your project.