Email Seminar 08 Part Questions - How To Send, Receive, and Automate Email With Attachments and Mail Merges in Microsoft Access


	Back to Email Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Email Seminar 08 Part Questions

Alexis Cao

4 years ago

i made the Access email database as Mr.Richard videos did, i checked many times about my vba code, it's same with video, but problem appears like the picture, which point is wrong, help

	Alexis Cao OP @Reply 4 years ago

	Alexis Cao OP @Reply 4 years ago

	Alex Hedley @Reply 4 years ago
Can you confirm `CurrentBalanceCurrentCustomerR` exists?

	Kevin Robertson @Reply 4 years ago
Is your Attach Folder a valid path? From your screenshot you may be missing a backslash (\).

	Alexis Cao OP @Reply 4 years ago
Dear Alex, i am sure CurrentBalanceCurrentCustomerR exists; and it doesn't miss the backslash

	Alexis Cao OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
I actually meant between Alexis and EmailSeminarTest. `C:\Alexis\EmailSeminarTest\`

	Alexis Cao OP @Reply 4 years ago

	Alexis Cao OP @Reply 4 years ago
no, Dear Kevin. it doesn't have the backslash

	Alexis Cao OP @Reply 4 years ago
Can i send the problem database to you? it will be easier. in fact i didn't modify the origan database expect the default folder

	Kevin Robertson @Reply 4 years ago
Sure. [email protected]

	Alexis Cao OP @Reply 4 years ago
has sent, Dear Kevin

	Kevin Robertson @Reply 4 years ago
You have 2 extra quotes on this line that aren't needed: `OutputFile = Forms!EmailF!AttachFolder & "BalanceReport-" & _ CustomerID & "-" & Format(Now(), "YYYYMMDD-HHNNSS") & ".PDF """` Change to: `OutputFile = Forms!EmailF!AttachFolder & "BalanceReport-" & _ CustomerID & "-" & Format(Now(), "YYYYMMDD-HHNNSS") & ".PDF"`

	Alexis Cao OP @Reply 4 years ago
Very thanks! Kevin. my attention focus on the error message , the yellow line words, i thought the problem is there. the vba said the "output to" problem. thanks thanks Bro

	Alex Hedley @Reply 4 years ago
Always worth `Debug.Print OutputFile` or `MsgBox OutputFile` and see what you get.

	Alexis Cao OP @Reply 4 years ago
nice, Alex.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Email Seminar Lessons.

Next Unseen

New Feature: Comment Live View