Search results

Hi There, OK, i have been doing some more research this morning and afternoon as the day to day at work has been rather slow. Is there a way that I can link my database to attach a particular file (PDF) each time the user goes to send either and acknowledgment or confirmation?

Hello DBguy, Sorry I guess it helps, espicially to help diagnose the problem. I received no error message it was more that it did not do what i had intended. The code you asked me to write in the immediate using Daniels code worked, however it did not ask me to attach files which is what I...

I am guessing your coding was the "SendEmail" bit at the end as the rest looks like what i typed, checked this and it did not work.

Oh Ok, i thought that was the code that was actually operating Outlook :banghead: Well i know you mentioned previously a template would be better however after speaking with colleagues at work they would prefer it to be pre filled text (memo Style, or like blank new email) I was dabbling in...

is this somewhere in the code that you recommended or do i add this at the bottom of existing code i pasted?

got ya, ok, so that worked, it bought up the outlook new message window in the format you had specified in the code.

OK, so this is copied exactly from his website. When i click the play button in the VBA to test code it asks me to save a macro? :confused::confused::confused: Option Compare Database --------------------------------------------------------------------------------------- ' Procedure ...

Thank you for the tip, i will have a look at this also, is this just a simple export the items from this Database and then import to my current DB? I am intrigued though on where all the message text goes or is it all derived from an attachment? The code I had used previously creates a memo...

Oh this was fun and been a head scratching thing, with still no results. I copied the code per your advisement and i still cannot get it open an outlook message window. What have i done wrong? Function SendEmail() Dim strTo As String Dim strSubject As String Dim strBody As String Dim bEdit...

Ok thank you. What I’ll do is put it all together tomorrow and do some trial and errors, if i get stuck I’ll ask the forum again.. [emoji106] Sent from my iPhone using Tapatalk

Would I just copy this code and then adjust to my needs? VBA is all very new to me so sorry if I’m asking lots of questions.. Sent from my iPhone using Tapatalk

Does anyone think that this is the best way forward or do I need to rethink my idea? Sent from my iPhone using Tapatalk

Hi All, So i have been testing a few codes and like the way this code works, because it is simple to use. This is the code below: Public Function SendEmail2() Dim varName As Variant Dim varCC As Variant Dim varSubject As Variant Dim varBody As Variant varName = "james@yahoo.com" varCC =...

Umm, so i had a read of this and I have to admit i don't get where I need to start.. let alone program it... (Poor understanding of VB) :banghead::banghead: Is there a layman term for this :)

Was there an attachment in this post?

Great.. easy is always better.. If you could provide some examples on how this is achieved that would be great. Does it require any VB programming as I haven’t a clue with that.. Sent from my iPhone using Tapatalk

I could use a template.. Sent from my iPhone using Tapatalk

Hi Dbguy. Yeah currently using Outlook 2016. Are you able to create bespoke emails with pictures etc or will be text only? Cheers.. Sent from my iPhone using Tapatalk

Hello all. You may have seen posts from me previously or even helped me, to which I am grateful, however I have another question in the hope that I can develop something.. Basically we record Information that is later used to send an order acknowledgment or an order confirmation via email...

Hey Isladog I just wanted to let you know all ok. Works wonders... Thanks for all the support.. Stuart. Sent from my iPhone using Tapatalk