Outlook email to different recipients with their individuals attachments

[NT100]

I'm working on ACCESS database, I need to send out an Outlook email to different recipients with their individuals attachments.

What would you suggest to do this? Is it possible to do without VBA, if VBA is used, how?

NT100

 

[isladogs]

This question came up as couple of days ago ... on this site if my memory is correct. Didn't you ask it?

If not, do a site search for this question

 

[Orthodox Dave]

Dear NT100,

Please forgive me for being bold, but I have noticed in your posts, you rarely close the thread with clear feedback as to whether the suggested code worked or not. 9 out of your 13 posts are left with someone offering a solution, but we don't know if it worked or not. And in one of the posts, 3 solutions were offered and you responded "It works, thanks", causing Ridders to ask "Just out of interest, which one worked?" to which there was no reply. And you didn't even click the Thanks button in this case.

Two points here:

Firstly, no-one gets paid for helping out in this forum, and this help can take hours. Knowing it helped someone is the "payment".

Secondly, these threads provide a mine of information directly searchable from Google. People with similar problems to yours can look up the threads to see what worked, sometimes years later.

 

[isladogs]

I agree totally. In fact I also wrote this in a previous thread...
https://www.access-programmers.co.uk/forums/showpost.php?p=1541547&postcount=2

@NT100
You've started several posts recently where various forum users have offered advice but you not always responded to them
For example:

https://www.access-programmers.co.uk...d.php?t=295031

https://www.access-programmers.co.uk...d.php?t=294994

Just wondering whether you are following up advice given in all threads?

If you solve a thread question yourself, the forum etiquette is to post your solution for the benefit of others

 

[Mark_]

https://www.access-programmers.co.uk/forums/showthread.php?t=296660

Just covered. You may want to search these forums for answers rather than asking first.

 

[NT100]

Dear NT100,

Please forgive me for being bold, but I have noticed in your posts, you rarely close the thread with clear feedback as to whether the suggested code worked or not. 9 out of your 13 posts are left with someone offering a solution, but we don't know if it worked or not. And in one of the posts, 3 solutions were offered and you responded "It works, thanks", causing Ridders to ask "Just out of interest, which one worked?" to which there was no reply. And you didn't even click the Thanks button in this case.

Two points here:

Firstly, no-one gets paid for helping out in this forum, and this help can take hours. Knowing it helped someone is the "payment".

Secondly, these threads provide a mine of information directly searchable from Google. People with similar problems to yours can look up the threads to see what worked, sometimes years later.

Thank you for the reminder, I'll close in due course. Thank you again.

 

[NT100]

I agree totally. In fact I also wrote this in a previous thread...
https://www.access-programmers.co.uk/forums/showpost.php?p=1541547&postcount=2

Links invalid.

 

[NT100]

This question came up as couple of days ago ... on this site if my memory is correct. Didn't you ask it?

If not, do a site search for this question

No. I don't think so.

 

[Gasman]

Links invalid.

Works for me?

 

[isladogs]

NT100

The first two work.
Not sure what happened to the last one. That also works if you go back to the thread where I wrote but not if clicked direct. Weird.

However please look back to your own previous posts and you will hopefully understand why there are some critical comments here

 

[Orthodox Dave]

Hi NT100,

If I read your question right, I am not sure it was answered by the other threads (correct me if I'm wrong Ridders, Gasman, Mark). You seem to be asking how to add different attachments to the email depending on who the recipient is, right?

But to answer this, please first tell us how you got on with your "Multiple attachments to Outlook email by ACCESS VBA" (posted 19th Oct).
https://www.access-programmers.co.uk/forums/showthread.php?t=296435
Your answer will help us to respond to this one. And we also need to see the code you are struggling with now.

If read at face value, your new question suggests you are completely new to VBA, which is unlikely, since you included some code in the previous post.

What would you suggest to do this? Is it possible to do without VBA, if VBA is used, how?

This VBA forum is mainly for Access users who are trying to write VBA code but have run into difficulties (e.g. it isn't working and they don't know why, or they want to do something new but don't know if it's possible, etc). It is there to help solve people's difficulties, not to teach people how to write VBA from scratch. If that is you, I would recommend you read Access VBA for Dummies (a book I use a lot!), or join a course to study VBA.

So to get the most out of this forum, your question needs to explain enough for site users to be able to understand exactly what problem you have run into, and offer a targeted solution if they have one. And to do this they really need the code you are having trouble with (with any confidential bits removed if necessary).

I hope that is helpful.