I'm using the following Shell Command to create a new Outlook message to send a fax:
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:Someone@Fax]
Now, It lets me do this:
Dim Var1
Var1 = me!Contact
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:" & Var1
But, it won't let me do this:
Dim Var1
Var1 = me!Contact
Var2 = me!Fax
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:" & Var1 & "@" & Var2 & "]"
It says it's an invalid command switch.
The True Question:
Does anyone know how I can make a single variable to equal [fax: [contact] @ [fax]] so I only use one variable to add to the shell command?
Thank you.
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:Someone@Fax]
Now, It lets me do this:
Dim Var1
Var1 = me!Contact
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:" & Var1
But, it won't let me do this:
Dim Var1
Var1 = me!Contact
Var2 = me!Fax
Shell "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.note /m [fax:" & Var1 & "@" & Var2 & "]"
It says it's an invalid command switch.
The True Question:
Does anyone know how I can make a single variable to equal [fax: [contact] @ [fax]] so I only use one variable to add to the shell command?
Thank you.