Recent content by MichelleB

What would make a computer work fine with this and then just stop? i cannot find reference issues with this, it looks the same on both computers?

Hi can i ask how you resolved it as i am having the same problem, worked fine on all my computers and then out of blue stopped working on two and only works on one computer now and i cant find solutions

IT was working fine on both computers then just stopped working on one for no reason that i can trace?

sorry i do not understand, what am i doing wrong please

Hi i have a script that creates an email for weekend bookings confirmation for musicians. it works perfectly on my computer and worked fine on my other computer till just recently and now it brings up error "13" when i try and run the object? the code is as follows and seems to be an issue when...

Hi again, i have a filter that shows the bookings for the weekend, which i can click on each act and it generates an email for then to confirm. however some acts have more than one booking on that weekend and i want to be able to list the bookings in one email, how would i do this please, the...

Thankyou thankyou thankyou, that worked perfectly. you are wonderful

firstly thankyou so much for you help it is greatly appreciated when i use this .Subject = "Week " & Format(Me.gigdate, "ww") & " " & Format(Me.gigdate, "mmmm") & " " & strSubject & " - " & act i get this Week 29 July Weekend Booking Checkoff - Greg McKew i need this Week 3 July Weekend...

sorry i need the week number in the month not the week number in the year, does that make sense

i need it to look like this Week 2 July Weekend Checkoff - act name

thanks for the quick reply, this gives me Week Friday 20 July Weekend Booking Checkoff - Greg McKew but does not list the week number as Week 3 Friday 20 July etc am i doing something wrong .Subject = "Week " & Format(gigdate, "ww") & " " & Format(gigdate, "mmmm") & " " & strSubject & " - "...

Hi i have a script that creates an email for a booking when i click on the artist name which works great. i want to be able to subject the email with the week number of the month. ie in subject it would be WEEK 1 JULY WEEKEND CHECKOFF. with the date info coming from gigdate field Private Sub...

hi i thought i would give some more info as i was very vague sorry. i have a filtered list created with a date range that generates a form view. i want to be able to on the generation of the form view create on the fly grouped emails from the records for each artist. so i they have two shows...

hi i need to be able to send an email from a filtered Form the form shows all bookings for the next week, i need to be able to group by a name field and the email lists all the bookings for that name any help please:eek:

Hi again, i have a script that generates an email for a booking html formatted. i need to be able to list more than one booking on the email i want to me able to send out emails for all musicians that are working that weekend to confirm their bookings. i have a form that lists all bookings for...