Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
!!Macro to attach pdf and reference excel!!
Hi Boys and Girls,
I need a bit of help with some macros. I am trying to create a macro that would automatically attach an pdf file to an email. Easy right? Well, the thing is that based on the receipient the file that is attached will change. So, when I attach the file it needs to reference a paticular cell and the path will indicate which file it should attach. If .attachments.add isn't he right approach, what would be? I have outlook 2000 and have the following macro already....any help would be awesome...THANK YOU! With olMyEmail .To = ActiveCell.Text .CC = ActiveCell.Offset(0, 1).Text .Subject = ActiveCell.Offset(0, 2).Text .Body = ActiveCell.Offset(0, 3).Text .Attachments.Add ----- NEED HELP HERE TO LOCATE FILE IN EXCEL CELL .Save End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
!!Macro to attach pdf and reference excel!!
.Attachments.Add Range("B9").Value
perhaps. or .Attachments.Add ActiveCell.offset(0,4).Value -- Regards, Tom Ogilvy " wrote: Hi Boys and Girls, I need a bit of help with some macros. I am trying to create a macro that would automatically attach an pdf file to an email. Easy right? Well, the thing is that based on the receipient the file that is attached will change. So, when I attach the file it needs to reference a paticular cell and the path will indicate which file it should attach. If .attachments.add isn't he right approach, what would be? I have outlook 2000 and have the following macro already....any help would be awesome...THANK YOU! With olMyEmail .To = ActiveCell.Text .CC = ActiveCell.Offset(0, 1).Text .Subject = ActiveCell.Offset(0, 2).Text .Body = ActiveCell.Offset(0, 3).Text .Attachments.Add ----- NEED HELP HERE TO LOCATE FILE IN EXCEL CELL .Save End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Attach macro to a cell | Excel Discussion (Misc queries) | |||
Excel macro to attach files in Outlook 2000 | Excel Programming | |||
Automatically attach Excel spreadsheet to Outlook Email with Macro? | Excel Programming | |||
How do you attach a macro in excel 2003? | Excel Discussion (Misc queries) | |||
De-Attach Macro?? Is there any way? | Excel Discussion (Misc queries) |