Search results

As you say, "Teach a man to fish..." Thanks.

My request for you to check the code was a mark of my insecurity, and lack of experience in debugging. However, after sorting a couple of glitches (it complained of a Wend without a While, which was there, confusing me greatly, and the actual problem was a missing EndIf (!) , and me taking the...

Here's my first stab at the modified code. the only bit I've added (or changed) is inserting If rstClone![Declined] = 0 Then (and its Else) All I'm asking is: have I inserted the extra IF, THEN, ELSE (referring to Declined) correctly? The code before is dim, rst, etc and defining msg...

I'm testing for if signed up, as there's no point in sending a form to those already signed up. (OK, no terrible consequences if you do, but....)

Yes, send form anyway (I said). Agreed, test for NOs first, before testing for 'if signed up'. I'll work on some code.

Not really the three states as you say. GA is encouraged as soon as they join. Some ignore/think about it/procrastinate etc; some sign up, and some say 'no I won't'. We send a GA Declaration form (what we are discussing) (which if filled in and returned we have to store adn show to HMRC as...

@Mark_ The code (above) says , I believe, IF GA flag is false 'member not signed up name a pdf file including GA in the filename generate that pdf Else just the Renewal the code comment:- 'Gift Aid Report Only Included If Selected should for clarity read...

"Why not..." well it does indicate just that, but that may be because some folk haven't got around to it or didn't consider it etc etc, The Declined is when some one specifically says they don't want to (and we have to assume they won't in the future, so we don't want to bug them with unwanted...

In english, it goes like this: they have signed up for GA so we put in a tick. Equally, if they have stated they do not want to get involved, a tick goes in 'declined' The code hasn't been changed and works as intended. I just need guidance on the VBA way of saying: if not signed up, and...

Thanks to the code from Daniel Pineault this is working very well with one 'fly in the ointment'. This correctly generates a gift aid form if a member's record for [Gift aid] is false. If rstClone![Gift Aid] = 0 Then strSubject = strSubjectGiftAid...

Yes, it is / does. (y)

Both the Gift Aid and Standing Order attachments ( referred to elsewhere as B & C) are governed by boolean fields. If a member is not signed up, there is no check mark, and the attachment is[are] sent to encourage doing it. The code I have looks [to me!] quite different to yours, but I believe...

I hadn't seen your post [this above] before I posted my last. Yes, not fair on Daniel, really. I probably should have insisted on telling mike more about what was required before he started his work.

Is it OK to post long blocks of code here? Hopefully. This is Daniel's code [below] which works well sending attachments A and B in a single email. (A very big thank-you to him!) My first question is where/how to add the additional code to check for attachment C ( the Standing Order) ? Can I...

Yes, I have flags in each member's record to control whether to include the B and/or C reports in each email. This all works with A and B, and it remains for me to sort out the code to additionally attach C when needed. Which, presumably, is simply a question of repeating the appropriate parts...

Yes, I am using the code on UA from Daniel Pineault. It's my problem that I can't see that the code you posted is simillar! EDIT: I see now where the similarity lies. Apologies.

Thanks, from what I can see, the code I have (which is working well, just needs extending) has tackled the problem in a very different way to the code you are showing me. (If you're interested it is in the thread referenced above in my msg 31.) But thank you.

in the block of code_ (at utteraccess.com/topics/2066496 ) Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon rstClone.MoveFirst While Not rstClone.EOF down to Wend On Error GoTo 0 There is a IF, Else, End If about Gift Aid Report...

Mike60Smart who was sorting out my problem for me, and getting advice on UtterAccess. (I'm typing some info for you, msg coming soon here.)

Thanks.