I think i have found my issue. I didn't have it as a Reference in Tools>Reference>MSOutlook Object Library.
There is only one thing i can't seem to work out. When the above file sends out emails, it would put spaces between the data, where i put <BR> but in calendar it doesn't. I tried to...
Hi, Thank you for your response.
This link is the one i used previously but with no avail. I just cant seem to change it from email to calendar. any help would be greatly appreciated.
Kind regards
Hi,
I'm currently at a stand still (as a novice) could someone please help!!
I currently use a Macro to find data in my Excel Workbook and send an email if it requires attention today. This works fine, but i would like to add the information to my Outlook calendar as an appointment instead...
Good afternoon,
Thank you for replying to my question.
I've had a look at that link previously and i couldn't get it to work for me.
I've attached a sample file of the WB i use.
Effectively, i have the macro find today's date in each sheet and if any return true, sends an email to a team...
Hi,
I currently use a number of Macros to organise my projects through Excel (one of which sends automated emails) however, i was looking at this information (the same that is sent via email) be added to my outlook calendar as appointments (as all day events).
I've tried a few variations but...
One final question / help. now that i have use this code and its now in practice.
The idea is that as soon as the workbook is opened it will send emails with all projects with today's date (works great).
Is the something i could add to like an If <Code> so that if Main1 + Main2 doesn't find...
Ken,
I sent that last message in haste as i have now added the 'NextJ:' in which has now made it all work perfectly.
Thank you so much for your assitance. i've learnt alot more about VBA from your help.
Kind regards
NextRW:
Next rw
Next rr
.AutoFilter.ShowAllData...
I've added that but getting a Compile error label not defined. seems to be highlighting the Goto Nextj bit
I've tried a few variations but no luck.
For j = 3 To aws.Index - 1
If r Is Nothing Then GoTo NextJ
Set ws = Worksheets(j)
With ws
If .AutoFilterMode = True Then...
Ken,
I've used this and has worked great. There is only 1 small issue that i hope you be able to help with.
If i run the macro and there is no data to be found. it will show an error and then not continue at this bit 'Run-Time error '1004' No Cells were found.
Set r =...
Hi Ken, I've put this spreadsheet in to practice over the past few weeks and seems to work brilliantly, so thank you for you help.
My Colleague, has added 2 further sheets (Key and Client List).
Would you be able to help again please?
i would like sheet 1 (Key) to be ignored and sheet 2...
I've tried again but still nothing. I've attached file in case I've changed something i shouldn't have.
The columns (G & K) were not in cell date format but now changed. The filter does filter, but doesn't show anything, even with today's date and prior dates until i un filter it back.
Thank you
Hi Kenneth,
I've done the test and it it give's a 'Run time error '1004':
AutoFilter method of range class failed.
This was done on a copy of my main spreadsheet and the cut and paste function wont work now either. It seems the filter is filtering the end date column, but not actually...
Hi Kenneth,
I'm really unsure what is going on. The email still doesn't populate and the get boiler routine is flagging up as an error. I've tried different dates over different days to check, just in case the routine to stop it sending twice was stopping it.
The transfer of rows to archive...
Added the code as above and added as module.
The data transfers perfectly to the archive if the date has elapsed. However, the email function is still not working.
Sorry to be a pain, but would you be able to have another look for me please?
Thank you in advance
Mike
That's great thank you.
The spreadsheet edits and moves across to the other archive sheet when i run it.
The email still doesn't seem to work, however i'll put in the data and will try open it tomorrow and see if that works.
Thank you again for your help and expertise.
Hi Kenneth,
Thank you for the coding above and your expertise, it is greatly appreciated.
I have entered the code and ran the spreadsheet but it doesn't seem to work. The rows have all closed up to row 128 when the end date in column G is applied including the title.
The email doesn't seem...
Hi,
Could someone help me with my query please? I have attached a sample spreadsheet for reference.
I’m a novice at VBA (very, very Basic understanding of VBA) and have tried multiple attempts with no avail.
I would like to create a VBA code to allow me to do the following;
Ø Check Column...