Search results

Greetings! I'm trying to use code designed by Allen Browne. I've followed his instructions (I'm pretty sure) on how to use the code and setting up the function. When I get into the query and when I type in "concatrelated" it even offers the tiny box that shows all the variables I need to...

Greetings, So I'm still learning to integrate HTML with VBA. I cannot figure out how to shade the table in my vba-generated email. I've seen some tutorials but I cannot successfully merge those lessons with how my code is laid out. Any help would be greatly appreciated. Ideally, the header...

Of course, my apologies for not being more clear. The way that I know to feed Access data into Word is through bookmarks. There may be another way but I am not familiar with it/them. So, because the size of the table (number of rows) is not fixed, I do not know how to use bookmarks to meet my...

Greetings, I'm stumped on this one. I need to populate a Word document with, among other things, a table with simple data. I know how to use bookmarks and I know how to populate them from Access. What I don't know is what to do when the number of rows changes with each record. How do I...

Greetings, I have scoured the site to find this exact issue and I haven't been successful. I have a table of applicants and a table of projects (applicants have one or more projects). For each applicant, an email is created and for each project a word document is created, saved, and attached...

Worked! Thanks!! I knew it was probably something I was just missing. I really appreciate it.

Greetings, I know this is a popular topic but I've read dozens of the related posts and none help me solve this problem. The code works perfectly without adding the attachment. When I try to add the attachment line I get "Operation Failed" error message. None of the other posts help me...