Search:
Type: Posts; User: brokovich
Search:
Search took 0.03 seconds.
-
Hi there
I used a second choose function for the selection of the email address. It's not the way I would have prefered to do it but it does work!
thanks.
B
-
Thanks for looking at this but I have now found a way to resolve the problem.
B :)
-
HI RobDog
Did you have any joy with the example i sent?
thanks
B
-
Here is a zipped version of the spreadsheet with the macro in it. The PMS Renewal October sheet the macro refers to is just a blank spreadsheet used as a template.
Hope this helps!
-
I changed it to this but I am still getting an error! It is now saying there is an application-defined or object-defined error??
EmailAddr = Application.VLookup(Sheets("Adviser...
-
Thanks. I have taken out the Error skip and it is erroring on this line:
EmailAddr = Application.VLookup(Range(sname), Sheets("Adviser Names").Range("B4:F6"), 5, False)
The problem is it is not...
-
Thanks Robdog,
Code attached as it works so far. This runs right through to the email with the attachment, but just doesn't select the relevant email address:
Sub SendActiveWorkbook()
Dim...
-
Thanks RobDog
I've now got it to the stage where it is running the macro and bringing up the email with the sheet attached, but not entering the email address. do you know how I can set the...
-
Thanks RobDog,
The problem I have is that the spreadsheet needs to be filtered for each individual, this selection copied into a tenmplate, and the template emailed to the individual. I tried...
-
Hi there
I am in the process of writing a macro that splits data on a spreadsheet, copies it into a new sheet, and then emails the new sheet to the relevant person before deleting the data.
I...
-
Sorry for delayed response. Been away, but the problem is still here!
The only info from the appointments I require is the Subject Field, Location, Start date and Time.
Thanks.
B
-
Thanks Rob Dog.
I did consider that option but I need to be able to distinguish between the owners of the appointments. Also, the individual people using the calendars should not really be able...
-
Can no one help with this?
B.
-
Hi all
I have developed a new system which uses information from a number of different people's outlook calendars. At the moment I am having to go into each profile and manually export their...
-
Hi There
I have a spreadsheet with approx 2300 rows on it. I need each row to be sorted in ascending order. Cell B in each row has the row heading, so i only want cells C to AM sorted.
To save...
-
Hi all
I am looking for some assistance with the export feature on outlook. I will soon have to export 65 calendars into excel files to link up with some excel code I have written.
This...
-
I'm not sure which bit of it isn't working, but it is not pasting anything at all into Sheet 2 and i am just getting an error box with 400 written in it... :(
-
Thanks Opus
That one doesn't seen to have worked. Someone else has suggested the following code:
Sub filterADE()
Sheets("Sheet1").Cells.autofilter 1, "ADE"...
-
Hi there
I am new to VBA and am trying to write some code to select a range of cells dependent on the content and copy and paste it into another worksheet.
I have attached a sample file so that...
|
Click Here to Expand Forum to Full Width
|