Hi Richard, I am making weekly payments to our suppliers, and I am using access database to run queries to generate payment remittances to individual suppliers in excel format. I want to run a macro to send these remittances by email via outlook.
Great tutorials. Question about sendobject... I have been using this exact code for many years with my default email client, windows Live mail. I have now installed and made Outlook my default (set as default app now in windows). The problem is access still wants to open WLM. Does sendobject not work with outlook, or am I missing another setting to default to outlook? I have one more using still using WLM, so ideally I would like the code to work with both outlook and WLM.
Expanding on this, I would like 1 command to send an invoice to the designated email for multiple companies. Example - I have 10 companies and would like to email their invoice out at the end of the month. Can this be done?
Hi Richard just wondering if you can do a video on how you made your website or how u linked your website to your ms access payment system as I’m making a e-commerce system like ur website for my computer shop using ms access as backend and classic asp for front end for customers also what do u recommend for a payment system like what you are using on your website bty I just love your website
Great Video! But when I tried to use the sendObject command it opens my Lotus notes email which we had when I made the database and was working when we were using lotus notes but, we recently switch to Outlook and M365 office. I updated my default email to outlook in windows and rebooted my PC but still wants to open Lotus notes . I am also trying the other option of using the outlook.application method to see if that will work but the the SendObject is less code. I tried looking for a default email setting in Access but could not find anything.
all thumbs up to the BEST ACCESS TEACHER RICHARD. Thank you for your other valuable tutorial. Already subscribed. Hope the others do the same. Question: How can I send the emails to specific group of clients (clients group is named after their residential city) Ex: Tampa, Buffalo, Westminster? thanks Richard
Thank you! Your video was very helpful.
You're very welcome
Thanks for the video, Richard. I didn't know about the "SendObject" command. I've always done it using the "olMailItem" method. 🙂
Any way to have the report in the body of the email instead of as an attachment?
Oh, I forgot I made this comment. I actually figured it out with some research over the internet.
Hi Richard, I am making weekly payments to our suppliers, and I am using access database to run queries to generate payment remittances to individual suppliers in excel format. I want to run a macro to send these remittances by email via outlook.
Great tutorials. Question about sendobject...
I have been using this exact code for many years with my default email client, windows Live mail. I have now installed and made Outlook my default (set as default app now in windows). The problem is access still wants to open WLM. Does sendobject not work with outlook, or am I missing another setting to default to outlook?
I have one more using still using WLM, so ideally I would like the code to work with both outlook and WLM.
Expanding on this, I would like 1 command to send an invoice to the designated email for multiple companies. Example - I have 10 companies and would like to email their invoice out at the end of the month. Can this be done?
Hi Richard just wondering if you can do a video on how you made your website or how u linked your website to your ms access payment system as I’m making a e-commerce system like ur website for my computer shop using ms access as backend and classic asp for front end for customers also what do u recommend for a payment system like what you are using on your website bty I just love your website
Great Video! But when I tried to use the sendObject command it opens my Lotus notes email which we had when I made the database and was working when we were using lotus notes but, we recently switch to Outlook and M365 office. I updated my default email to outlook in windows and rebooted my PC but still wants to open Lotus notes . I am also trying the other option of using the outlook.application method to see if that will work but the the SendObject is less code. I tried looking for a default email setting in Access but could not find anything.
How to send pay slip email to each employee with 1 click, thank's
all thumbs up to the BEST ACCESS TEACHER RICHARD. Thank you for your other valuable tutorial. Already subscribed. Hope the others do the same. Question: How can I send the emails to specific group of clients (clients group is named after their residential city) Ex: Tampa, Buffalo, Westminster? thanks Richard
YOU SPARKED A NEW IDEA IN ME