Recent content by ChristopherL

Thank you! Sorry for late reply, I've been on vacay :) I am quite new to this and how it works.. So for this to run a macro called macro1 and VBA function "sendemail". How do I make that work? :P

Hi there, I have a report that I run manually from my computer every day. This report is created by a macro in microsoft access, then it runs a VBA macro to send it out.. Is there a way that I can add this as a schedueled task since I usually forget to send it out? :p Regards, C

Ohhh I am stupid! This works perfect, truly thankful!

Woho, this seems to be a script that I can definetly use! Thank you for this so much :) One thing tho, how do I setup the attachPath? :P Regards, Chris

A collegue of mine told me that it is what we should use for sending out the report.. My concern now is editing the title of the file instead.. Right now it's named after the query, I want to create my own name of the file as it's converted to pdf :D? Do you know if it is possible to this code...

Thank you for that, I'll see what I can do with it :) What about the saving part? :D / Regards C

Hi there, I am in need of a solution for sending out my report with a date variable.. I have two reports that are being generated through a macro. What I want to do is send out these reports as PDF-files with names like: Counterparty report as of =date() Counterparty 0 report as of =date()...

Hey.. I am not a great VBA writer, but I believe this easiest could be solved with VBA.. If it's not to hard for you mby someone can help me? :) I want a macro that sends out two reports with subject "Counterparty Price Report As Of =Date()" And I want the attatched report be sent out as a...

Thank you, but.. How will that affect the subject of the email? :P

Hi, I am using a EmailDatabaseObject to send out a report for my job. I want to add a date variable in the subject.. Is this possible? Like Report as of =date() 2nd. Question.. Can I attach two reports in the same mail? Best Regards, C

In your query, where the criteria box just enter "A" Or "B". If you use the 'like' operand you need to have a wildcard, such as like "%A" or "%B". and to make it easy for you, here's two example with like and just common where in sql-view. select * from mytable where yourcolumn = '%A%' or...

Here's what you can do instead. If your workbook is static(you will use the same workbook always to export your queries). Then you can link your queries to each sheet through excel to your access query, and update inside excel instead of importing from access. You can even create a macro in VBA...

"In need to feed a cell table with the value of the number of streets that are in "Type1" cyties" What does this mean? You want to make a query that selects all cities with type1? I don't understand the end-product you want.

Glad I could help, good luck! Regards, C

Hey sorry for late answer but I have been out of office. select fieldA from form1 union all select fieldA from form2 you have to write in the sql editor.